Dollar sign Expansion with greater than or less than operator

[#1]

Hi ,

I am new to qlikview and I am not too sure how to write set analysis statements. I have read the help file but I have still not understood how to do this.

The requirement is to get the total sales between two dates which are variables --> var_startdate and var_enddate

I tried writing something like this:

=

sum({<DateTime={">$(#var_startdate)<$(#var_enddate)"}>} Sales

)

But this does not work. Please help.

Regards

Raj

[#2 · Accepted solution]

Try this:

=sum({<DateTime={">$(var_startdate) <$(var_enddate)"}>} Sales)

If that doesn't work try using either let or set in the script (whichever one you didn't use the first time).

[#3]

Hi Trent,

That worked. thank you.

I do not know why the help file had the '#' symbol in the syntax...

Thanks

Raj