topic Re: parameterized variables in App Development

parameterized variables

ali_hijazi — Wed, 08 Nov 2017 15:31:53 GMT

Hello

I'm working on qlikview dashboard

I need to create a variable that takes parameters

I created it as follows:

vmaxDate as =max({1<YEAR=$::YEAR,MONTH_NUM={$1}>} trx_date)

I put a text box object and put in it the following:

$(vmaxDate(1))

but I get null whereas if I put in the definition 1 instead of $1 I get correct value

kindly advise

Re: parameterized variables

sunny_talwar — Wed, 08 Nov 2017 15:35:17 GMT

How about if you do like this

=Max({1<YEAR=$::YEAR, MONTH_NUM={'$1'}>} trx_date)

Re: parameterized variables

ali_hijazi — Wed, 08 Nov 2017 16:06:02 GMT

it worked if I put Month_Num={"$(=$1)"}

but if the variable definition begins with equal sign I always get null

kindly advise

does parameterized variables work only if the definition doesn't start with equal sign?

Re: parameterized variables

ali_hijazi — Wed, 08 Nov 2017 16:16:22 GMT

how do I call the variable $(vmax_date(1))

Re: parameterized variables

rwunderlich — Wed, 08 Nov 2017 18:01:42 GMT

You should not use an equal sign at the beginning of this variable definition. A leading = means "calculate this immeadiately", You want to defer calculation until the variable is called,

-Rob