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 ?
