topic Re: How to use variables in expressions in QlikView

How to use variables in expressions

Thu, 21 Mar 2013 12:50:34 GMT

I have this expression in pivot table:

sum( {$<AcNo= {'>=3000<=3999'},VoDt= {'>20130101<20130328'}>} AcAm)

I like to use variables from_date and to_date (ihave created) instead of 20130101 and 20130328. How to do that?

//Gunnar

Gysbert_Wassenaar — Thu, 21 Mar 2013 12:54:29 GMT

Use dollar-expansion. This looks like $(vMyVariable) for a variable name vMyVariable

sum( {$<AcNo= {'>=3000<=3999'},VoDt= {'>$(from_date)<$(to_date)'}>} AcAm)

fdelacal — Thu, 21 Mar 2013 12:55:04 GMT

sum ( {$<AcNo= {'>=3000<=3999'},VoDt= {"$(='>='& MonthStart(date(vHOY),-2)&'<='&MonthEnd(date(vHOY),0)"}>}AcAm)

vHOY = DATE(TODAY())

Hope it helps you.

Regards.

Thu, 21 Mar 2013 13:02:29 GMT

try this

sum( {$<AcNo= {'>=3000<=3999'},VoDt= {'> $(from_date) < $( to_date )'}>} AcAm)

Thu, 21 Mar 2013 13:04:48 GMT

What do $ sign mean in the syntax?

//Gunnar