combining several variables in an expression

Thu, 06 Sep 2012 15:05:00 GMT

Hi,

first i want to say that i make use of QlikviewComponents-5.1, a great component.

From that component I have a year to date variable which allows me to show YTD sales :

sum( $(vSetYTD) Sales)

this works fine,

but i dont know how to combine it with another constraint, for example while using a Flag = P

How do i put that into one formula, i tried to separate with a comma, but that doesnt work...

and can i also store the Flag = P in a formula, vFlag, so I just have to call vSetYTD and vFlag into one expression?

thanks

Re: combining several variables in an expression

rwunderlich — Tue, 18 Dec 2012 14:28:28 GMT

This feature is now available in Qlikview Components V6. Each Calendar Set expression now has a corressponding xxxModifier variable that contains only the set modifier values, It can be combined with other modifiers like this:

Sum({< $(vSetYTDModifier), Region={US}>} Sales)

-Rob

topic Re: combining several variables in an expression in QlikView

combining several variables in an expression

Re: combining several variables in an expression