topic Re: Using calculated dimensions in charts/graphs in QlikView

Using calculated dimensions in charts/graphs

lucasdavis500 — Wed, 25 Nov 2020 16:16:04 GMT

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 =

"$(=Month(AddMonths(Date(Today()),-2)))"

Re: Using calculated dimensions in charts/graphs

sunny_talwar — Thu, 17 Nov 2016 14:13:10 GMT

May be like this:

=If(Model2.Month_Res = Month(AddMonths(Today(), -2)), Model2.Month_Res)

Re: Using calculated dimensions in charts/graphs

lucasdavis500 — Thu, 17 Nov 2016 14:16:15 GMT

That worked, I suppose having the variable in there added an extra '=' in

Re: Using calculated dimensions in charts/graphs

sunny_talwar — Thu, 17 Nov 2016 14:25:24 GMT

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

Re: Using calculated dimensions in charts/graphs

lucasdavis500 — Thu, 17 Nov 2016 14:40:09 GMT

=if(Model2.Month_Res = $(vTwoMonthLag), Model2.Month_Res)

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

Re: Using calculated dimensions in charts/graphs

buzzy996 — Thu, 17 Nov 2016 14:56:39 GMT

hi,I think u have to create tht variable in load script and u can use on ur chat,tht will work.