Variable Problem

[rohitians]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[rohitians]

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