Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
laznfin1
Contributor
Contributor

Results of Field in Action

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

2 Replies
rafaelattux
Luminary Alumni
Luminary Alumni

Hi Paul,

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

select in field.PNG

laznfin1
Contributor
Contributor
Author

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