Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Wanted not select current month and year and yet wanted display LY YTD it is possible

Hi All

i like SET expression to achieve above for my expression below :-

money(

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} sales/$(ColumnDim77)/1000)

, $(vMoneyFormatK_N))

The reasons for not select current month and year is create less work at initial selection.

paul

0 Replies