topic Re: Percentage in chart in QlikView

Percentage in chart

qlikviewwizard — Fri, 09 Oct 2015 08:12:17 GMT

Hi All,

How to show the percentage like -20,-10,0,10,20,....90,100,...in x-axis?

Now it is showing on the top of the chart.

Data:

Load * INLINE [

PRODUCT,2015 Change,2014 Change

Iphone,2514,2240

Ipad,2318,3219

Mac,-1,7589,2509

Android,-3415,3367

];

Percentage Expression: =([2014 Change]-[2015 Change])/[2015 Change]

Thanks in advance.

Re: Percentage in chart

Fri, 09 Oct 2015 08:34:59 GMT

Hi Arjun,

Did you try setting the 'Static min' to -0.1, 'Static max' to 0.1 and 'Static step' to 0.05 in the 'Axes' tab of chart properties?

Regards

Re: Percentage in chart

qlikviewwizard — Fri, 09 Oct 2015 08:36:21 GMT

Hi MadhuraNadgauda

I am new to this. Could you please do help me.

Re: Percentage in chart

Fri, 09 Oct 2015 08:40:30 GMT

Hi Arjun,

I am not sure if that could solve your problem but, did you try changing the settings for min and max limits of the axis? Those are in the 'Axes' tab of the chart properties.

Regards

Re: Percentage in chart

jsingh71 — Fri, 09 Oct 2015 08:48:40 GMT

Hi Arjun,

See the ttachment :

Re: Percentage in chart

Anonymous — Fri, 09 Oct 2015 10:20:29 GMT

Hi Arjun,

In Axes Tab,

Change position to Left(Bottom) you will get expected output.

Hope it helps!!

Re: Percentage in chart

Fri, 09 Oct 2015 10:55:43 GMT

Hi,

What is your expected output?

Re: Percentage in chart

qlikviewwizard — Fri, 09 Oct 2015 11:02:30 GMT

Percentage :

=([2014 Change]-[2015 Change])/[2015 Change]

2015 Sales:

sum([2015 Change])

2014 Sales:

sum([2014 Change])

2015 Sales:

sum([2015 Change])

Re: Percentage in chart

qlikviewwizard — Fri, 09 Oct 2015 12:12:04 GMT

Could you please tell me the steps ? I am still confused .

Re: Percentage in chart

qlikviewwizard — Fri, 09 Oct 2015 14:00:41 GMT

This is the solution from jsingh71