Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about if you do like this
=Max({1<YEAR=$::YEAR, MONTH_NUM={'$1'}>} trx_date)
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?
how do I call the variable $(vmax_date(1))
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