topic Variable Problem in QlikView

Variable Problem

rohitians — Wed, 24 Apr 2013 06:58:05 GMT

Hello,

I have a scenario for Inventory ageing where in am using a variable

vDateForAgeing=

=IF(ISNULL(GetFieldSelections(MonthName))=0 OR ISNULL(GetFieldSelections(FinancialYear))=0,DATE(MAX(PostingDate)),DATE(Today()))

but when i reload it says VDateForAgeing field not found I am not able to find the error.

Please Help

Thanks and Regards,

Rohit Yadav

nilesh_gangurde — Wed, 24 Apr 2013 07:29:18 GMT

Hii,

Your syntax should be as mentioned below.

=IF(ISNULL(GetFieldSelections(MonthName)) OR ISNULL(GetFieldSelections(FinancialYear)),

DATE(MAX(PostingDate)),

DATE(Today()))

try this one...

-Nilesh

Wed, 24 Apr 2013 07:33:19 GMT

try this

=IF(GetFieldSelections(MonthName)=0 OR GetFieldSelections(FinancialYear)=0,

MAX(DATE(PostingDate)),DATE(Today()))

hope this helps you.

rohitians — Wed, 24 Apr 2013 07:34:47 GMT

Really Sorry guys i dint used $ sign in script...

Thanks and Regards