Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

stack Bar chart with percentage by dimension

Capture.PNG.png

Dear Experts,

would you please help me to show the percentage of the stack bar chart with percentage by dimension?

if i just check the check box 'value on data points' and 'relative' , it will show percentage, but it is not related to the dimension by month, the whole year is 100%. but i want to make 100% by month.

thanks for your kind help.

Manie

1 Solution

Accepted Solutions
ecolomer
Honored Contributor II

Re: Re: Re: Re: Re: stack Bar chart with percentage by dimension

Or that?

p10.png

9 Replies
ecolomer
Honored Contributor II

Re: stack Bar chart with percentage by dimension

My proposal for you

Not applicable

Re: stack Bar chart with percentage by dimension

Dear Enrique,

Thanks for your prompt reply.

However,  i want to show the QTY value like 20, 40, 60, 80, 100 on the Y-axis, then on the bar chart , should be 100% in Jan, 100% in Feb, in Mar, A should be 42% and B should be 58%.

2014-09-29_13-45-55.png

thanks,

best regards,

Manie

ecolomer
Honored Contributor II

Re: Re: stack Bar chart with percentage by dimension

Yes, ¿now?

p10.png

Not applicable

Re: stack Bar chart with percentage by dimension

2014-09-29_13-45-55.png

Dear Enrique,

it doesn't work if the total quantity isn't equal to 100, so you can't just divide 100....

P.S. i don't know how to upload QVW in the reply section... so i didn't attach the QVW...

thanks,

best regards,

Manie

ecolomer
Honored Contributor II

Re: Re: stack Bar chart with percentage by dimension

To attach a file you need select in the corner up in right (avanced editor) and then you have the option to upload a file

ecolomer
Honored Contributor II

Re: Re: stack Bar chart with percentage by dimension

In the expression:

Sum(Qty)/Sum( TOTAL <Month> Qty)

And Number select %

p10.png

Not applicable

Re: Re: Re: stack Bar chart with percentage by dimension

Dear Enrique,

it works on your simulation, but i try, it didn't work on my dashboard.

Please find the attachment, i have make it a little bit complicate:

we need to show two groups of product in legend: 'top 3 product' as one group and the others exclude by top 3 belongs to 'others'

and the top 3 product is base on monthly sales, not yearly sales, which means the top 3 customer in Apr, is based on Apr's QTY, not whole year's QTY.

it should looks like this:Untitled.png

so would you help?

thanks,

best regards,

Manie

ecolomer
Honored Contributor II

Re: Re: Re: Re: stack Bar chart with percentage by dimension

Now?

p10.png

ecolomer
Honored Contributor II

Re: Re: Re: Re: Re: stack Bar chart with percentage by dimension

Or that?

p10.png

Community Browser