Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Arjunarao
Honored Contributor II

Percentage in chart

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.

Capture.PNG

1 Solution

Accepted Solutions
Partner
Partner

Re: Percentage in chart

Hi Arjun,

See the ttachment :

chart.png

9 Replies
Not applicable

Re: Percentage in chart

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

Arjunarao
Honored Contributor II

Re: Percentage in chart

Hi MadhuraNadgauda

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

Not applicable

Re: Percentage in chart

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

Partner
Partner

Re: Percentage in chart

Hi Arjun,

See the ttachment :

chart.png

qlikviewnovice
Valued Contributor II

Re: Percentage in chart

Hi Arjun,

In Axes Tab,

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

Hope it helps!!

Not applicable

Re: Percentage in chart

Hi,

What is your expected output?

Arjunarao
Honored Contributor II

Re: Percentage in chart

Percentage :

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

2015 Sales:

sum([2015 Change])

2014 Sales:

sum([2014 Change])

2015 Sales:

sum([2015 Change])

Arjunarao
Honored Contributor II

Re: Percentage in chart

Hi

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

Arjunarao
Honored Contributor II

Re: Percentage in chart

This is the solution from jsingh71

Capture.PNG