Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Venamma23
New Contributor II

Calculating the difference between last Friday's data and current Friday's data for the entire data

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
DateWeekdayOrder CountGrowth/decline
01/07/2019Monday3 
02/07/2019Tuesday4 
03/07/2019Wednesday5 
04/07/2019Thursday3 
05/07/2019Friday66
08/07/2019Monday7 
09/07/2019Tuesday4 
10/07/2019Wednesday5 
11/07/2019Thursday3 
12/07/2019Friday82
15/07/2019Monday6 
16/07/2019Tuesday2 
17/07/2019Wednesday4 
18/07/2019Thursday6 
19/07/2019Friday91
22/07/2019Monday4 
23/07/2019Tuesday3 
24/07/2019Wednesday5 
25/07/2019Thursday6 
26/07/2019Friday4-5

Could you please help me with this..

 

Regards,

Venamma

2 Replies

Re: Calculating the difference between last Friday's data and current Friday's data for the entire d

Why this value as "11" instead "1"

19/07/2019Friday911
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Venamma23
New Contributor II

Re: Calculating the difference between last Friday's data and current Friday's data for the entire d

Yes its supposed to be 1 , edited now.