Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

combining several variables in an expression

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

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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