How to write the script ?

[suvechha_b]

Hi All,

I have declared a variable vSelect in my sample model which has the value - which the user will select 'Fiscal Year' and 'Fiscal Period'

eg,

vSelect = =GetFieldSelections([Planning Year])  * 100 + GetFieldSelections([Planning Period])

201601

I want to use this variable in the qlikview script -

select * as vCurrMonth FROM JNBVDW02A.[edw].[dbo].[qlk_dim_period] where [Fiscal Year] >=2015 and [fiscal_month_key]=vSelect;

How to do that ?

sample attached.

Thanks,

[sunny_talwar · Accepted solution]

Try using a trigger to assign numeric value to vSelect and then try to use it in the script

[suvechha_b]

Hi Sunny ,

Didn't got you

Please show by screenshot.

Any also show how to write in script.

Many Thanks,