topic Sum dimension's value in a bar chart in QlikView

Sum dimension's value in a bar chart

Thu, 24 May 2012 07:15:20 GMT

Hi,

I have a bar chart with a dimension country and in my expression i want to sum 2 country on my dimension.

I try this :

IF(DimCountry="Marseille",

Sum( {$<DimCountry = {“Marseille”,”Aix en Provence”}>} Montant ),

Sum(Montant)

)

but that doesn't work...

How have to I make ?

Thanks a lot.

Sum dimension's value in a bar chart

swuehl — Thu, 24 May 2012 08:12:00 GMT

You still get only the value for Marseille?

I believe you need to use a total qualifier in your sum, where you want to retrieve values for dimension values outside your current (Marseille) dimension scope:

IF(DimCountry="Marseille",

Sum(total {$<DimCountry = {“Marseille”,”Aix en Provence”}>} Montant ),

Sum(Montant)

)

Sum dimension's value in a bar chart

Thu, 24 May 2012 08:23:32 GMT

Thanks a lot !!!