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

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

Hi,

I am trying to write a set analysis expression like below:

=Sum({<FIS_CAL_WEEK_ID ={">=Max(FIS_CAL_WEEK_ID)-12 <=Max(FIS_CAL_WEEK_ID))"}>} TOTAL_QTY)

The objective sum of Total Quantity where it will start from Maximum week number and will show only 13 weeks in the chart.

Thanks

10 Replies
Not applicable
Author

Thanks for the ans