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: 
paulyeo11
Master
Master

SET expression YTD how to change to Last month ? if user not select year and month.

Hi All


I have below expression display YTD target amount  is working fine :-


SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales_target/Rate/1000)


usually i can make use of below expression to make it work :-

Sum({$< Month_n  ={"2"}>} sales_target/1000)/Rate 

But due to Month_n field is not link to sales_target , so i have to use SET analysis.


Hope some one can advise me.



Paul Yeo

0 Replies