Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Average Sales

Hi, can anyone help me on how to display the sales for the last FULL week (MONDAY to SUNDAY).

I have sales being loaded in daily, On my chart i have a dimension that displays the sales for the date selected, but i also want a column next to it that displays the sales for the last full week. this figure should then stay the same until the next MONDAY where the figure will change to display sales for the previous week.

Is this possible?

3 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

you can use the datefunktion week() and with set analysis you get the sales of the week before

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

you can use Week(datefield) and with set analysis you get sales of the week before - pardon for entering it twice,

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Ok thanks Martina, Do you have an example of the set analysis??