Discussion Board for collaboration on QlikView Layout & Visualizations.
I need to create a filter for my dimension where it should only show data from the past 12 months from the current month.
Anyone know how to do this?
It is easy to do in set analysis but I need it for my Dimension instead and not measure.
So in essence a Dimension restricted to the last 12 months values only.
Go to Solution.
Use this as your calculated dimension
If(Date >= AddMonths(Today(), -12), Date)
May be like this
If(Date >= AddMonths(Max(TOTAL Date), -12), Date)
and then make sure to select 'Suppress when value is Null'
To make it work with selections, make sure to ignore Date field in set analysis and let your dimension drive selections and range
How can I do this where I can say Date = only dates from the past 12 months from today
It's the expression after the = that I need. I am not sure whether it should be an = or >= or <=.