Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

See why BI users voted Qlik #1 in 11 categories. GET REPORT
Showing results for 
Search instead for 
Did you mean: 

Calculate 30 Days back data from weekend date in Qlik Sense on bar graph

I have a data for 3 years which is stored in Qlik QVD. In bar graph, I need show the data by week for a selected year.

For e.g if we look at July 2019, the week starts from 23rd July (Tuesday) and ends on 29th July (Monday). Lets say this is week 30 of the year.

So for week 30, avg daily sales in = ( sum (all sales in from 29th June – 29th July including 29th June and 29th July)   /   no. of days  including 29th June and 29th July).

Can help to do this ?

0 Replies