topic Re: How to use variables in expression sets in QlikView

How to use variables in expression sets

Anonymous — Tue, 12 Jun 2012 14:17:41 GMT

Hi Everyone,

I'm trying to use an expression that filters my results depending on a variable. I have a variable v_Previous_Date which has the previous date found in the max value from the Date field (max(Date))

I need to make work an expression like this:

sum({$<Date=$(v_Previous_Date)>} Amount)

It doesn't work. Does anyone can help me?

Re: How to use variables in expression sets

Miguel_Angel_Baeyens — Tue, 12 Jun 2012 14:22:46 GMT

Hi Jose,

Try the following instead:

Sum({< Date = {'$(=Date(v_Previous_Date))'} >} Amount)

Hope that helps.

Miguel

Re: How to use variables in expression sets

MayilVahanan — Tue, 12 Jun 2012 14:23:54 GMT

hi,

Try this,

= Sum({<Date = {'=$(=v_Previous_Date)'}>}Amount)

Hope it helps

Re: How to use variables in expression sets

Anonymous — Tue, 12 Jun 2012 14:30:10 GMT

It works, thanks everyone!

Re: How to use variables in expression sets

rwunderlich — Tue, 12 Jun 2012 14:35:09 GMT

You'll need braces around the value.

sum({$<Date={$(v_Previous_Date)}>} Amount)

Since you stored max(Date) in a variable, it's a string so probably in mm/dd/yyyy format. You may need single quotes around the value as well.

sum({$<Date={'$(v_Previous_Date)'}>} Amount)

-Rob