topic Re: Bar chart with 3 differents expressions/bars in QlikView

Bar chart with 3 differents expressions/bars

Wed, 18 Jul 2012 13:45:35 GMT

Hello,

I want to do a bar chart with 3 bars per year (like : All Sales, Sales for 3 departements and Sales for 5 departements) and 2 dimensions (Years and months).

My problem is with the expression. I have 3 differents expressions for the 3 bars. I don't know how to write my selection in the expression.

Like : Sum( [Sales] & [where departement = (X, Y, Z)] & [where year ='1998 & 1997'] )

If you have any advice or website to give me, please don't hesitate.

Tks for your help.

Re: Bar chart with 3 differents expressions/bars

Miguel_Angel_Baeyens — Wed, 18 Jul 2012 13:52:40 GMT

Hi,

This should work

Sum({< Department = {'X', 'Y', 'Z'}, Year = {1997, 1998} >} [Sales])

Hope that helps.

Miguel

Re: Bar chart with 3 differents expressions/bars

MayilVahanan — Wed, 18 Jul 2012 13:57:49 GMT

HI,

Try like this,

=Sum({< Year={'1998',1997'}>}Sales)

=Sum({<Departements = {'1','2','3'}, Year={'1998',1997'}>}Sales)

=Sum({<Departements = {'1','2','3','4',5'}, Year={'1998',1997'}>}Sales)

Hope it helps

Re: Bar chart with 3 differents expressions/bars

Wed, 18 Jul 2012 15:04:22 GMT

It works !

Thank you for your help and your efficacy !