topic Re: How to make stack chart all bar same height ? in QlikView

How to make stack chart all bar same height ?

paulyeo11 — Thu, 13 Jun 2013 13:06:49 GMT

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 — Thu, 13 Jun 2013 13:11:23 GMT

Enclosed my QV Doc

Anonymous — Thu, 13 Jun 2013 13:22:42 GMT

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

Thu, 13 Jun 2013 13:35:00 GMT

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

paulyeo11 — Thu, 13 Jun 2013 13:43:56 GMT

Hi Rebecca

nice link , me like those creative art. Thank

paulyeo11 — Sat, 15 Jun 2013 14:47:25 GMT

Hi All

Can some one share with me.