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

tambechetan — Sat, 16 Nov 2024 20:17:07 GMT

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 ?

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

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