How to convert Month_n to SET ?

paulyeo11 — Thu, 24 Mar 2016 10:54:49 GMT

Hi All

I have below expression from Table 2 which is using Month_n and need to select current month and year :-

money(

sum({$<Month_n={$(=max(Month_n)-0)}, month=, year=>} $(ColumnDim51)/$(Columndim89)/1000)

,$(vMoneyFormatK))

I like to change the above expression by using SET with don't need to select on current month and year. and it will return current month sales.

Paul

topic How to convert Month_n to SET ? in QlikView