topic Re: Select in field Action in QlikView

Select in field Action

Tue, 04 Sep 2012 11:09:20 GMT

Hi,

I have a Select in field action on a button:

Field: Month

Search string: =vMonth

In script: LET vMonth = Month(Today());

What am I missing? Think I have tried everything but at present the selected month still is June... (Starting from no choices made...)

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager

Advectas AB

Miguel_Angel_Baeyens — Tue, 04 Sep 2012 11:10:59 GMT

Hi,

Use this code in the search string instead:

=$(vMonth)

Make sure the formats of the field corresponds to the variable.

Hope that helps.

Miguel

Tue, 04 Sep 2012 11:32:51 GMT

Hi,

I tried that too, but without result. If I'm checking Settings/Variable Overview

vYear = 2012

vMonth = sep

So far , so good. But no Month is selected...

/Toby

Miguel_Angel_Baeyens — Tue, 04 Sep 2012 11:40:03 GMT

Hi Toby,

Check the attached QVW file with an example. Note that the Month field has been created in the script using the Month function as well.

Hope that helps.

Miguel