topic Re: Not able to check the condition in QlikView

Not able to check the condition

Thu, 05 Feb 2015 14:35:14 GMT

Hi Friends,

I have declared a variable like this

LET vAccountingPeriod=Date#(ADDMONTHS(YEARSTART(Now()),-12),'YYYYMM');

Which is equal to 201401.

and loaded the data like

Load * from table

where Date#([Acct-PrdOO],'YYYYMM')>Date#($(vAccountingPeriod),'YYYYMM');

But I am getting all the data and the check condition is failing.

Please let me know the error in the code.....

Thanks

Re: Not able to check the condition

Thu, 05 Feb 2015 14:39:29 GMT

As you have already set the format in the variable, you should be able to just use

where Date#([Acct-PrdOO],'YYYYMM')>'$(vAccountingPeriod)';

hope that helps

Joe

Re: Not able to check the condition

Gysbert_Wassenaar — Thu, 05 Feb 2015 14:41:39 GMT

Try:

LET vAccountingPeriod= floor(ADDMONTHS(YEARSTART(Now()),-12));

Load * from table

where floor(Date#([Acct-PrdOO],'YYYYMM')) > $(vAccountingPeriod);

Re: Not able to check the condition

Thu, 05 Feb 2015 14:49:38 GMT

Hi Gysbert

Its working!!! Could I know the reason please

Re: Not able to check the condition

Gysbert_Wassenaar — Thu, 05 Feb 2015 14:58:50 GMT

When using dates in comparisons it's often wise to use only the numeric value and not mess around with the different format string representations of the dates.