Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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