Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
paulyeo11
Valued Contributor III

How to make stack chart all bar same height ?

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

5 Replies
Highlighted
paulyeo11
Valued Contributor III

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

Enclosed my QV Doc

Highlighted
jonbrough
Valued Contributor

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

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

Highlighted
Not applicable

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

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/

Highlighted
paulyeo11
Valued Contributor III

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

Hi Rebecca

nice link , me like those creative art. Thank

Highlighted
paulyeo11
Valued Contributor III

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

Hi All

Can some one share with me.