topic Re: Percentage on chart expression with two dimensions in QlikView

Percentage on chart expression with two dimensions

sifatnabil — Wed, 26 Jul 2017 12:15:45 GMT

Hi all,

Normally with 1 dimension on a bar chart, we can get a "% of total" value at the bottom of each bar by ticking "invisible" and "text on axis" like below:

However, the % value does not work when using 2 dimensions. Is there any way to preserve the % values while having 2 dimensions?

Re: Percentage on chart expression with two dimensions

PrashantSangle — Wed, 26 Jul 2017 12:28:35 GMT

can you provide sample data with required output???

Regards,

Re: Percentage on chart expression with two dimensions

sifatnabil — Wed, 26 Jul 2017 12:36:18 GMT

Hi, please see attached. I'm trying to get the % values on the second chart in my app, just like the first chart. The second chart has 2 dimensions.

Re: Percentage on chart expression with two dimensions

stigchel — Wed, 26 Jul 2017 12:49:33 GMT

In display options remove the bar option, see attached

Re: Percentage on chart expression with two dimensions

sifatnabil — Wed, 26 Jul 2017 12:54:37 GMT

Thanks - however, when there are 2 parts on a bar chart, it's showing 2 %s, e.g. 20% and 7% in your attachment for Dimension "C". Is there a way for it to have a singular value = 27%?

Re: Percentage on chart expression with two dimensions

stigchel — Wed, 26 Jul 2017 13:08:01 GMT

Change the expression to calculate the total and only display for the first row

if(Rowno()=1,

sum(TOTAL <Sector> [Order size])

sum(TOTAL [Order size])

,'')

Re: Percentage on chart expression with two dimensions

sifatnabil — Wed, 26 Jul 2017 13:24:25 GMT

That's awesome, thanks. I noticed that the %s aren't on the same horizontal alignment, is there a way to align them?

Re: Percentage on chart expression with two dimensions

stigchel — Wed, 26 Jul 2017 13:58:32 GMT

I don't think so...