Results of Field in Action

[Anonymous]

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

[rafaelattux]

Hi Paul,

You can use this option ( Actions ) in either Text or Button object.

[Anonymous]

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