Set analysis

Thu, 25 Sep 2014 16:53:31 GMT

Hi All,

I am facing an issue with set as I am trying to create MTD by using below expression:

(sum({<Month_No_SM1={"$(=num(month(max(Date_SM1))))"},Year_SM1={"$(=max(Year_SM1))"},Date_SM1={"<$(=max(Date_SM1))"}>}QUANTITY_SM1)

sum({<Month_No_SM1={"$(=num(month(max(Date_SM1))))"},Year_SM1={"$(=max(Year_SM1)-1)"},Date_SM1={"<=$(=date((AddYears(max(Date_SM1),-1)),'MM/DD/YYYY'))"}>}QUANTITY_SM1))

sum({<Month_No_SM1={"$(=num(month(max(Date_SM1))))"},Year_SM1={"$(=max(Year_SM1)-1)"},Date_SM1={"<=$(=date((AddYears(max(Date_SM1),-1)),'MM/DD/YYYY'))"}>}QUANTITY_SM1)

and its picking up the wrong dates.

Data I have till 24 Sep 2014 however its giving me the figures of 23 Current Year and 24 for last year.

Can anyone help?

Thanks

topic Set analysis in QlikView

Set analysis