Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to create a filter for the "Next 3 months" (I'm also doing last 3 months but the principle is the same).
In my SQL script I have added in the field v_Next3 like this..
,case DATEPART(m, getdate())
when 1 then '("Feb"|"Mar"|"Apr")' and so on.
I want to use this field in a filter, populated from an action. So, the user presses the button which takes them to the sheet and applies the correct filter.
My problem is, being fairly new to Qlikview, is I dont how to apply the variable V_next3 to the filter. I want it to 'populate' the Select In Field Action with the exact string ("Feb"|"Mar"|"Apr"), but it doesn't seem to do anything!
Do I have to Set or Call this variable somewhere in order to get it work?
Many thanks
Hi Paul,
You can use this option ( Actions ) in either Text or Button object.
Thanks Rafael. I got to that bit but it wasn't returning the correct result.
I changed it to use a Qliview Variable rather that a SQL field and it woks fine!
Many thanks for taking the time to help