Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted

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)
Highlighted
Contributor III
Contributor III

Yes its supposed to be 1 , edited now.