topic Re: How to get it in variable ? in QlikView

How to get it in variable ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

How to get it in variable . The selection in filter.

See the screenshot

For eg,

vExample should contain 2017Mar

Sample attached.

ciaran_mcgowan — Mon, 04 Jul 2016 12:57:55 GMT

=GetFieldSelections([Planning Year]) & GetFieldSelections([Planning Month])

MK_QSL — Mon, 04 Jul 2016 12:58:36 GMT

=Date#(max([Planning Year])&Date(Max(Date#([Planning Month],'MMM')),'MMM'),'YYYYMM')

sunny_talwar — Mon, 04 Jul 2016 12:58:45 GMT

I added two triggers... 1 to Planning Year Field and the other one to Planning Month field to get this.

ThornOfCrowns — Mon, 04 Jul 2016 13:13:36 GMT

This was the reply I was typing, but have been ninja'd again!

Create the variable vExample

Go to Settings|Document Properties|Triggers

For both Planning Year and Planning Month

Add an Action for On Select

Choose Add|External|Set Variable

Enter the variable name vExample

Enter =GetFieldSelections([Planning Year])&GetFieldSelections([Planning Month]) as the Value