Bar chart problem

djallelsadki — Tue, 06 Sep 2011 16:03:25 GMT

Hi,

I have the following bar chart :

dimension "indic" which is set to "Total" and "Detail"

and a second dimension "Category" which has the values: "Chicken", "Frozen ",....

my formula is:

=if(indic<>'detail',

count({<Distributeur=>} num_ligne)/count( {<Distributeur=>}Total num_ligne)

,count({$<Catégorie>}num_ligne)/count( {$<Catégorie>}total num_ligne))

here's what I get

by selecting multiple distributors :

The problem is here :

when I select a single distributor, i get this

values belonging to the total appear

whereas what I want is :

I hope this is clear,

thanks,

Djallel Sadki

topic Bar chart problem in QlikView

Bar chart problem