Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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