topic Input box properties linked to script in QlikView

Input box properties linked to script

jozisvk11 — Tue, 14 Nov 2017 13:46:30 GMT

I have script :

LET today_year = Year(now());

[Transaction]:

Load

[t_otyp] as [ID transakcie],

[t_odoc] as [Number of transaction],

[t_olin] as [Line],

[t_fprd] as [Fiscal month],

[t_fyer] as [Fiscal year],

;

SQL SELECT

*

FROM [dbo].[ttfgld106107]

Where ([t_fyer] = $(today_year))

It works OK.

But also I want to choose fiscal month. But fiscal month I want to choose in object input box properties. I try write it (red colour is what does´nt work😞

LET today_year = Year(now());

LET Start = PurgeChar(Start, ' ');

IF FindOneOf(today_month, ',') then

LET today_month = Num#(Start) + 0;

Transaction]:

Load

[t_otyp] as [ID transakcie],

[t_odoc] as [Number of transaction],

[t_olin] as [Line],

[t_fprd] as [Fiscal month],

[t_fyer] as [Fiscal year],

;

SQL SELECT

*

FROM [dbo].[ttfgld106107]

Where ([t_fyer] = $(today_year)) and ([t_fprd] = $(today_month));

COULD YOU HELP ME, how I can write for example:

8 into object, save and then reload. Realod will be for 8 month. Thank you.