Set analysis possible?

[AnnaEKinch]

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

[Saravanan_Desingh]

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:

[AnnaEKinch]

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