topic Re: how to show percentage data in age pyramid bar chart? in QlikView

how to show percentage data in age pyramid bar chart?

marjan_it — Sun, 29 May 2016 07:30:16 GMT

H make a Age Pyramid bar chart like the image. it works good when I show data as integer but when I want to show data in Percent

the left Piece of bar chart shows negative percent data.

what can I do to show all data in positive percent?!

swuehl — Sun, 29 May 2016 16:39:29 GMT

Try using the dual() function, like

=Dual( Num( Count(FIELD) / Count(TOTAL FIELD),'#.00%','.',','), -Count(Field) )

for the left side expression and

=Dual( Num( Count(FIELD) / Count(TOTAL FIELD),'#.00%','.',','), Count(Field) )

for the right side expression.

Disable the 'relative' option.

marjan_it — Mon, 30 May 2016 10:25:50 GMT

I do this but it doesnt work. in this case shoe data in number not percent and show in negative.

swuehl — Mon, 30 May 2016 11:16:44 GMT

Could you upload a small sample QVW?

marjan_it — Tue, 31 May 2016 04:54:20 GMT

Yes of course. this is my sample.

swuehl — Tue, 31 May 2016 12:11:52 GMT

Ok, I would need to check why my suggestion did not work.

But you can make your approach work by changing the format code in number tab to

#,##0%;#,##0%;

i,e, specifiying a format for the negative values without a minus sign.

marjan_it — Wed, 01 Jun 2016 05:12:34 GMT

Thanks so much. this is work goood