Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need some help (SetAnalysis)

Hi!

I need som help, I'm working on a document which should show the Sales Amount and Sales Total for Week1. of the period selected.

For example. If I choose the dates February 6th to February 26th it should show me the figures for week1 (6th till 12th) etc.

How do i do this?

I tried like this:

Sum({$<Week={">=$(=max(Week),-1)) <=$(=(max(Week)))"}>} PRICEOUT)

but that gives me the summary of the last week choosen.

10 Replies
Not applicable
Author

Will do! I'll just need to test it some more!

Thanks again!