topic Applying more than one condirion in chart expression in QlikView

Applying more than one condirion in chart expression

Thu, 15 Jul 2010 05:36:12 GMT

I have a chart with following expression

sum({$<Year={$(vThisYear)}>}SalesValue)

It currently outputs a single line with total sales for this year. I want to show additional lines by breaking the total sales down by Region ie add a second condition to the other lines eg where Region = 'Asia'

Can someone please help out with the code

Thanks, Rainer

Applying more than one condirion in chart expression

Thu, 15 Jul 2010 06:18:37 GMT

Hi Rainer,

Plz see attachment for the solution.

Formula shall be like this:

Sum

({<Year = {"2001","2002","2003","2004","2005","2006"},Region = {"A"}>}Sales)

Sincere regards,

Happy Thoughts

Applying more than one condirion in chart expression

Thu, 15 Jul 2010 06:47:04 GMT

Thankyou very much. It did the trick.

I don't understand the positioning and grouping requirement of the '{}' and the '<>' but I guess it doesn't matter.

If I add a further parameter then I would the comma before the '>' and enclose the values for the field within the '{}' eg sum({$<Year={$(vThisYear)},Region={'Ade'},ProductGroup={'Fruit'},SalesMan={'Jackson'}>}SalesValue)

Thanks again.

/Rainer