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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!