Qlik Sense App Development

Not applicable

stack Bar chart with percentage by dimension

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.

Manie

Tags (6)
1 Solution

Accepted Solutions
Honored Contributor II

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

Or that?

9 Replies
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,

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%.

thanks,

best regards,

Manie

Honored Contributor II

Yes, ¿now?

Not applicable

Re: stack Bar chart with percentage by dimension

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

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

Honored Contributor II

Re: Re: stack Bar chart with percentage by dimension

In the expression:

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

And Number select %

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:

so would you help?

thanks,

best regards,

Manie

Honored Contributor II

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

Now?

Honored Contributor II

Or that?