How to make stack chart all bar same height ?

[paulyeo11]

HI All

I have a stack bar chart , the bar display the actual sales value . So the bar some are high and some are low.

My aim is to make all the bar same height , so i am able to view which is the high contribution % Exp from year by year changes.

I aware that the code should look some thing like below :-

=if(aggr(sum(sales),$(ColumnDim10)) / aggr(sum(total <$(ColumnDim_p)> sales), $(ColumnDim10)) > 0.001, $(ColumnDim10), ' Other')

But i am not able to apply here.

Hope some one can share with me.

Paul

[paulyeo11]

Enclosed my QV Doc

[Anonymous]

Can't look at your example yet as I'm doing a reload.

Sounds like you want to show the relative proportions of the primary aggregation, split by a secondary dimension.

Have you tried ticking the Relative checkbox on the expression ?

Jonathan

[#4]

There is a graph exampe on my website that shows all bars the same size.  It may help you.  See here:

http://intuiqlik.com/2013/03/27/infographics-in-qlikview/

[paulyeo11]

Hi Rebecca

nice link , me like those creative art. Thank

[paulyeo11]

Hi All

Can some one share with me.