topic bar chart y-axis in QlikView

bar chart y-axis

Tue, 07 Oct 2014 12:45:03 GMT

Hi All,

I'm having a bar chart whose expression uses avg function. The values of this expression indicate percentage values as shown in screenshot 1.

I wanted to display % after every value so I tried concatenating % as follows avg()&'%' . This is displaying % after the expression value but Y-axis numbering is changed. As shown in Screenshot 2 Y-axis is having 0.20 when it has to display 20 and same is with other number. Is there any way to avoid this ?

Screenshot 1 :

Screenshot 2 :

Thank you!!!

Re: bar chart y-axis

Gysbert_Wassenaar — Tue, 07 Oct 2014 12:49:15 GMT

Try dual(avg(MyField) & '%', avg(MyField))

Re: bar chart y-axis

ashfaq_haseeb — Tue, 07 Oct 2014 12:53:28 GMT

Hi,

Remove % and on expression click relative.

Regards

ASHFAQ

Re: bar chart y-axis

Tue, 07 Oct 2014 12:55:37 GMT

Thank a lot