Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_Date | Order_ID |
15/10/2019 | EXP_1 |
15/10/2019 | EXP_2 |
15/10/2019 | EXP_3 |
15/10/2019 | EXP_4 |
16/10/2019 | EXP_1 |
16/10/2019 | EXP_2 |
16/10/2019 | EXP_5 |
16/10/2019 | EXP_6 |
17/10/2019 | EXP_5 |
17/10/2019 | EXP_7 |
17/10/2019 | EXP_8 |
17/10/2019 | EXP_9 |
17/10/2019 | EXP_10 |
Expected Output:
15/10/2019 | 16/10/2019 | 17/10/2019 | |
New Orders Received | 4 | 2 | 4 |
Could you please help me..
Regards,
Venu