topic Re: Custom Y-axis in bar chart in QlikView

Custom Y-axis in bar chart

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to custom y axis in bar chart, actually i have vales like 100 to 1000. If i take these values into bar chart as expression, Y axis is appears 0, 200, 400 ..... 1000 (vertically) by default however, i want to show y axis like 0, 50, 100, 150..............1000 (vertically).

How can i make it without increasing/expanding chart size.

Thanks,

Nihhal.

Re: Custom Y-axis in bar chart

boorgura — Mon, 09 Apr 2018 17:50:31 GMT

In the chart properties, Axes tab -->use a static step of 50. That should help you.

Re: Custom Y-axis in bar chart

nihhalmca — Mon, 09 Apr 2018 17:54:17 GMT

Tried Rakesh, no use. You also try it if possible.

Re: Custom Y-axis in bar chart

boorgura — Mon, 09 Apr 2018 18:14:14 GMT

can you please post a sample QVW?

Re: Custom Y-axis in bar chart

nihhalmca — Mon, 09 Apr 2018 18:39:50 GMT

LOAD * INLINE [

Product, Price

A, 100

B, 200

C, 500

B, 800

E, 300

F, 1000

];

Re: Custom Y-axis in bar chart

Anil_Babu_Samineni — Tue, 10 Apr 2018 01:36:09 GMT

The static step should be measure level? Can you show image at least.

Re: Custom Y-axis in bar chart

Nagaraju_KCS — Tue, 10 Apr 2018 04:07:19 GMT

Hi Nihhal,

Static Step Should work, but problem is it won't fit the values difference 50 gap..

Without expand chart, it won't fit, because we don't have enough space in Y-axis.

See here which i have marked, i given Static step 80, this is working.... if you give less than it won't appear.. because don't have enough space...

Suppose if you have less price... 50 difference difference should appear.. because values fit the scale..

Note: Without expand the chart, it won't work 50 difference.

Hope it helps....

Re: Custom Y-axis in bar chart

Nagaraju_KCS — Tue, 10 Apr 2018 04:29:39 GMT

I have an idea..

you can decrease font size in Y-Axis, that should appear 50 difference. But if you have more than this amount it won't work...

Re: Custom Y-axis in bar chart

nihhalmca — Mon, 16 Apr 2018 07:55:05 GMT

Yes Raju, I tried this and i mentioned in question as 'How can i make it without increasing/expanding chart size'.

Any ways thanks for your help.