Using Math Functions on a Variable Expansion

[Anonymous]

I have a variable (vMinSales from a slider) that I'm using in a set modifier that I want to multiply by 1000, Sum ({$< Sales_Value = {">$(#vMinSales)*1000"}>} Sales_Value), but the syntax does not work. I tried several variations, but none work. Is the only option to create a second variable and multiply it by 1000 and use that variable instead, or is there some syntax that will work?

[jagan · Accepted solution]

Hi,

Try this

=Sum ({$< Sales_Value = {">$(=vMinSales*1000)"}>} Sales_Value)

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Works perfectly. Thanks.

Just out of curiosity, where would you find that in the reference manual. I'd like to read more about using variables.

[jagan]

Hi,

This is there in Qlikview Help file by pressing F1 and goto the Set Analysis topic.

Regards,

Jagan.