topic Re: How to make a bigger bars in bar chart in QlikView

How to make a bigger bars in bar chart

Fri, 18 Sep 2015 07:17:16 GMT

Hi experts,

I am displaying a report in bar chart. Problem is that one value is very big(having big bar) as compared to other values so that their bars are very small and non-readable.

Plz suggest me how to make increased heights of these bars so that they become readable and noticable.

Thanks in advance

Larib

Re: How to make a bigger bars in bar chart

marcus_sommer — Fri, 18 Sep 2015 08:11:38 GMT

You could enable for this axis the exponential scala or you divide your big dimension-value / 1000 or 1000000 and displayed it with a special unit like k or m - but both methods could confuse the user and you need to display it very clearly that there are some special adjustments within this object.

- Marcus

Re: How to make a bigger bars in bar chart

Fri, 18 Sep 2015 08:14:24 GMT

Hi,

Are you using two expressions or only one.

Re: How to make a bigger bars in bar chart

ankit777 — Fri, 18 Sep 2015 08:22:28 GMT

Hi,

Try to set Scale for your graph. Also provide a static max.

Re: How to make a bigger bars in bar chart

jonathandienst — Fri, 18 Sep 2015 08:22:56 GMT

It sounds like a simple bar chart is not a useful visualisation in this case. You could exclude the vary large bar and simply show the smaller items. You could show the % for the large bar as text or in a gauge of some type. Or do both.

Re: How to make a bigger bars in bar chart

jonathandienst — Fri, 18 Sep 2015 08:24:49 GMT

I would not put all the data on the same chart with different axes - I think this will confuse your users and give no useful information of the relative sizes of the small and large obects.

Re: How to make a bigger bars in bar chart

Fri, 18 Sep 2015 08:56:44 GMT

one expression

Re: How to make a bigger bars in bar chart

Fri, 18 Sep 2015 09:05:47 GMT

Sir, I have to show all data on single chart...

If this data is more informative with other table type...Plz suggest other table typ...

Re: How to make a bigger bars in bar chart

marcus_sommer — Fri, 18 Sep 2015 09:14:42 GMT

Like above mentioned you could try it with exponential scaled axis or using different units for the data - but should this not be suitable you could only use a table-chart then none graphical object could really cover these big differences between the dimension values.

- Marcus