topic Re: Using Math Functions on a Variable Expansion in QlikView

Using Math Functions on a Variable Expansion

Anonymous — Tue, 02 Jul 2013 19:06:19 GMT

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?

Re: Using Math Functions on a Variable Expansion

jagan — Tue, 02 Jul 2013 19:12:43 GMT

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.

Re: Using Math Functions on a Variable Expansion

Anonymous — Tue, 02 Jul 2013 19:17:56 GMT

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.

Re: Using Math Functions on a Variable Expansion

jagan — Tue, 02 Jul 2013 19:19:21 GMT

Hi,

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

Regards,

Jagan.