topic Help Required: Y Axis have multiple dimension in QlikView

Help Required: Y Axis have multiple dimension

Mon, 12 May 2014 10:40:54 GMT

Hi All,

Y Axis have multiple dimentions named as YValue1 , YValue2, YValue3. The challenge is in YValue1 total sum is shown but in YValue2 i have to show avg. The number format of YAxis i need to change when i select YValue1 it should show as number format but when i select YValue2 it should show as %.

File attached.

Thanks

Re: Help Required: Y Axis have multiple dimension

cfz — Mon, 12 May 2014 11:08:33 GMT

Hi Manish,

Try choosing an appropiate (for instance fixed to 2 decimals) Number Format Settings and then select Show in Porcent in the Number tab of the Properties of the object.

I hope it helps.

Carlos

Re: Help Required: Y Axis have multiple dimension

Tue, 13 May 2014 06:20:27 GMT

Thanks Carlos,

By doing this all values (including YValue1) will be show in percentage. But i want to show YValue1 as number format and rest as percetage format.

Hope i am able to explain my problem.

Thanks

Re: Help Required: Y Axis have multiple dimension

Thu, 15 May 2014 05:42:34 GMT

Hi All,

Please suggest any solution to this problem.

Thanks