Set analysis possible?

AnnaEKinch — Sun, 03 Oct 2021 16:50:45 GMT

Hi!

I need to count the number of orders that have been approved on a certain date.

The date I am showing in the table is "TobeReceivedDate". I need to count the number of Orders "TobeReceived" on that date and the number of orders "Approved" on that date.

My calendar is based on totally different dates so I can't use that.

This is my dataset:

TobeReceivedDay	To be Received Date	%ORDERKEY	Approved Date	ApprovedDay
Mo	2021-09-06	4726745\|1\|3	2021-09-06	Mo
Mo	2021-09-06	4730533\|1\|1	2021-09-06	Mo
Mo	2021-09-06	4730689\|1\|1	2021-09-06	Mo
Mo	2021-09-06	4736931\|2\|1	2021-09-06	Mo
Mo	2021-09-06	4736931\|3\|1	2021-09-06	Mo
Tu	2021-09-07	4734551\|1\|1	2021-09-06	Mo
We	2021-09-08	4731509\|1\|1	2021-09-06	Mo
We	2021-09-08	4731509\|1\|2	2021-09-06	Mo
Th	2021-09-09	4726745\|1\|1	2021-09-06	Mo
Th	2021-09-09	4733620\|1\|1	2021-09-06	Mo
Th	2021-09-09	4738134\|1\|1	2021-09-06	Mo
Th	2021-09-09	4738134\|1\|2	2021-09-06	Mo
Fr	2021-09-10	4726745\|1\|2	2021-09-06	Mo
Fr	2021-09-10	4733834\|1\|1	2021-09-06	Mo
Fr	2021-09-10	4737933\|1\|1	2021-09-06	Mo

This is the result I wish to achieve:

TobeReceivedDay	To be Received Date	Count of TobeReceivedOrders	Count of ApprovedDate Orders
Mo	2021-09-06	5	15

Re: Set analysis possible?

Saravanan_Desingh — Mon, 04 Oct 2021 01:48:17 GMT

Try something like this,

Dimension: Approved Date

Expressions:

Only({<[To be Received Date]=p([Approved Date])>}TobeReceivedDay)

Only({<[To be Received Date]=p([Approved Date])>}[To be Received Date])

Count({<[To be Received Date]=p([Approved Date])>}[To be Received Date])

Count([Approved Date])

Hide the Dimension (Approved Date)like this,

Output:

Re: Set analysis possible?

AnnaEKinch — Tue, 05 Oct 2021 13:03:03 GMT

Hi! Thanks, I couldn't get it to work in Qlik Sense. I made a new table in the data model instead.

topic Re: Set analysis possible? in App Development

Set analysis possible?

Re: Set analysis possible?

Re: Set analysis possible?