topic Month in QlikView

Month

NavinReddy — Wed, 02 Apr 2014 18:56:05 GMT

Dear All,

Please find the image

In this i want to fetch only 2014 ,Feb Data as Current month

for that month i should took only FEB,

Please create a variable that shows only Feb

=Sum({1<Month={"<=$(=Max(Month))"},Year={'2014'}>}PAY_AMT)

This expression Im getting Both the Months Data How can i Fetch only FEB

Please Help Some one

Thanks In Advance

Niru

Re: Month

maxgro — Wed, 02 Apr 2014 19:29:19 GMT

=Sum({1<Month={FEB},Year={'2014'}>}PAY_AMT)

Re: Month

Gysbert_Wassenaar — Wed, 02 Apr 2014 19:35:22 GMT

Change Month={"<=$(=Max(Month))"} into Month={"$(=Max(Month))"}. The <= means smaller or equal. You want an exact match so don't use the <= comparison operator.

Re: Month

swuehl — Wed, 02 Apr 2014 19:37:51 GMT

Just change the smaller equal to an equal comparison or

=Sum({1<Month={'$(=Max(Month))'},Year={'2014'}>} PAY_AMT)

Re: Month

NavinReddy — Wed, 02 Apr 2014 20:28:28 GMT

No it will change month automatically

there i need to use variable only