Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: combining several variables in an expression

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

Community Browser