Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

How to calculate previous week

Hi,

I need to show previous week's data from the attached QVD based on the current date, means current date's previous week will be calculated and data will have to be shown according to that week.

Please let me know how to achieve that.

Thanks,

Sandip

12 Replies
parul_mehta
Partner - Creator
Partner - Creator

Please try this for the previous week calculation based on Order Date

Sum({<[Order Date] = {'$(=Date(Max([Order Date])-7))'}>}sales)

parul_mehta
Partner - Creator
Partner - Creator

Hi

Please check this. It works for last week calculation

Not applicable

Hi Sandip,

Hope you are well.

Have you had a chance to look at the replies yet?