topic Re: Expression not working in QlikView

Expression not working

Thu, 25 Sep 2014 18:52:45 GMT

Hi All,

The expression that I am trying to use to calculate the MTD is not working :

(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)

Data I am using was Last reloaded on 24 Sep 2014.

Dates I am getting is 23 Sep CY and 24 LY whereas I want 23 Sep CY as well as for last year.

Can anyone help.Its Urgent.

Thanks

Re: Expression not working

geert_gelade — Thu, 25 Sep 2014 19:57:50 GMT

Could it be the equal sign marked in red ?

(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)

Re: Expression not working

Fri, 26 Sep 2014 04:15:21 GMT

Hi,

Thanks for the reply.

I don't think that's an issue.

Thanks

Re: Expression not working

senpradip007 — Fri, 26 Sep 2014 04:32:25 GMT

Have you tried as Geert advised?

Re: Expression not working

Fri, 26 Sep 2014 04:44:25 GMT

Hi,

I think its working however I am still verifying.

Thanks