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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
10 Replies
Not applicable
Author

Thanks for the ans