Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Venamma23
Contributor III
Contributor III

Calculation of new orders received day to day

Hi,

I'm quite new to QlikSense and I'm trying to calculate the New orders received every day in my data set.

Ex: data source

Order_DateOrder_ID
15/10/2019EXP_1
15/10/2019EXP_2
15/10/2019EXP_3
15/10/2019EXP_4
16/10/2019EXP_1
16/10/2019EXP_2
16/10/2019EXP_5
16/10/2019EXP_6
17/10/2019EXP_5
17/10/2019EXP_7
17/10/2019EXP_8
17/10/2019EXP_9
17/10/2019EXP_10

Expected Output:

 15/10/201916/10/201917/10/2019
New Orders Received424

Could you please help me..

 

Regards,

Venu

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

Use a pivot table
Put order date and dimension and count(Order_id) as measure.
Move order date to a column instead of a row.

Not sure if i am over simplifying your need