Discussion board where members can get started with QlikView.
I'm using a calculated dimension one of my charts
=if(Model2.Month_Res = $(vTwoMonthLag), Model2.Month_Res)
On the charts themselves, the dimension seems to return "Null"
Is this the proper way to calculate a single month for a dimension??
where vTwoMonthLag =
Go to Solution.
May be like this:
=If(Model2.Month_Res = Month(AddMonths(Today(), -2)), Model2.Month_Res)
That worked, I suppose having the variable in there added an extra '=' in
Yes that could have been the issue, but I am not sure how you have your variable setup and this is why gave you a direct expression without any variable
where $(vTwoMonthLag) = "$(=Month(AddMonths(Date(Today()),-2)))"
so it was definitely the variable, I have that variable stored for Set analysis, not use in a dimension
hi,I think u have to create tht variable in load script and u can use on ur chat,tht will work.