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..
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?