Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jozisvk11
Contributor

Input box properties linked to script

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.