topic Re: Variable Problem in QlikView

Variable Problem

rohitians — Wed, 24 Apr 2013 06:57:23 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

Re: Variable Problem

Gysbert_Wassenaar — Wed, 24 Apr 2013 08:12:42 GMT

How are you using vDateForAgeing in your expressions? You probably need to dollar-expand it: $(vDateForAging). Also, Qlikview is case sensitive so ABC is not the same as Abc or abc. So vDateForAging isn't VDateForAging.

Re: Variable Problem

rohitians — Mon, 29 Apr 2013 09:27:35 GMT

Hello,

I am

=IF(ISNULL(GetFieldSelections(MonthName))=0 ORISNULL(GetFieldSelections(FinancialYear))=0,

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

I am using this expression in first sheet and the montname and financial year cmes in the last sheet in master calender,

it says field not found ..how do i tackle this..

Thanks