topic Re: Re: stack Bar chart with percentage by dimension in App Development

stack Bar chart with percentage by dimension

Sat, 16 Nov 2024 11:29:15 GMT

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

Re: stack Bar chart with percentage by dimension

ecolomer — Mon, 29 Sep 2014 03:51:36 GMT

My proposal for you

Re: stack Bar chart with percentage by dimension

Mon, 29 Sep 2014 05:50:35 GMT

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

thanks,

best regards,

Manie

Re: Re: stack Bar chart with percentage by dimension

ecolomer — Mon, 29 Sep 2014 05:54:22 GMT

Yes, ¿now?

Re: stack Bar chart with percentage by dimension

Mon, 29 Sep 2014 06:18:15 GMT

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

Re: Re: stack Bar chart with percentage by dimension

ecolomer — Mon, 29 Sep 2014 06:20:40 GMT

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

Re: Re: stack Bar chart with percentage by dimension

ecolomer — Mon, 29 Sep 2014 06:23:34 GMT

In the expression:

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

And Number select %

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

Mon, 29 Sep 2014 07:05:59 GMT

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

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

ecolomer — Mon, 29 Sep 2014 07:31:46 GMT

Now?

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

ecolomer — Mon, 29 Sep 2014 07:36:20 GMT

Or that?

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

PuriVelasco — Mon, 09 Nov 2020 16:30:56 GMT

Hello @ecolomer , your solution doesn't run in Qlik Sense.

Do you know how I can do the same in Qlik Sense? I have

Count(ALTURA_MODULO) / count(total <[AÑO]> ALTURA_MODULO) because I want to obtain the total amount of ALTURA_MODULO per year but I only obtain a relative result.

Thank you very much.