Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I'm quite new to Qlik sense and I have a requirement like i need to get difference between current Friday's orders count and previous Friday's order count as Friday to Friday variation ,which should be generic for the entire data set.
for example If I have 23 weeks data in my data set and I have to show this difference for every Friday (in comparison with Previous Friday).
Expected | |||
Date | Weekday | Order Count | Growth/decline |
01/07/2019 | Monday | 3 | |
02/07/2019 | Tuesday | 4 | |
03/07/2019 | Wednesday | 5 | |
04/07/2019 | Thursday | 3 | |
05/07/2019 | Friday | 6 | 6 |
08/07/2019 | Monday | 7 | |
09/07/2019 | Tuesday | 4 | |
10/07/2019 | Wednesday | 5 | |
11/07/2019 | Thursday | 3 | |
12/07/2019 | Friday | 8 | 2 |
15/07/2019 | Monday | 6 | |
16/07/2019 | Tuesday | 2 | |
17/07/2019 | Wednesday | 4 | |
18/07/2019 | Thursday | 6 | |
19/07/2019 | Friday | 9 | 1 |
22/07/2019 | Monday | 4 | |
23/07/2019 | Tuesday | 3 | |
24/07/2019 | Wednesday | 5 | |
25/07/2019 | Thursday | 6 | |
26/07/2019 | Friday | 4 | -5 |
Could you please help me with this..
Regards,
Venamma
Why this value as "11" instead "1"
19/07/2019 | Friday | 9 | 11 |