topic How to write the script ? in QlikView

How to write the script ?

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

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 — Tue, 12 Jul 2016 10:39:08 GMT

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

suvechha_b — Tue, 12 Jul 2016 11:03:42 GMT

Hi Sunny ,

Didn't got you

Please show by screenshot.

Any also show how to write in script.

Many Thanks,