topic Re: Bar Chart in QlikView

Bar Chart

Tue, 14 Jan 2014 07:36:05 GMT

Hi All,

I have a bar chart as shown below

As you can see since x-axis values are huge bars are not seen properly.

So I was just thinking of displaying only one bar for entries with a particular number. Say one bar for all entries with 2, then when you click on that bar it will display all entries having value 2. Same with other numbers.

Is there any way to do this in qlikview ? Or any other better approach to display all values properly?

[Please note that I have already enabled x-axis scroll bar]

Re: Bar Chart

Colin-Albert — Tue, 14 Jan 2014 07:42:16 GMT

You could use dimension limits to only show values that are above a specific value or Greater than X% relative to the total.

Also, as you have already enabled the X-axis scrollbar, consider reducing the number of visible items so fewer but larger bars are shown.

Re: Bar Chart

datanibbler — Tue, 14 Jan 2014 07:44:55 GMT

Hi kavitakadli,

sure you can do this. You have to turn the chart around:

- the value (or value ranges) would be the dimension (x-axis)

- the nr. of bars with this value (range) (with names if needed) would be the expression (y-axis).

=> Look up "IntervalMatch" in the help file on how to do that - or, if you have some book on QlikView, you'd need an "aggregated dimension"

HTH

Best regards,

DataNibbler

P.S.: The "IntervalMatch" is part of the LOAD statement which generates the data for your dimension

Re: Bar Chart

Colin-Albert — Tue, 14 Jan 2014 07:57:54 GMT

On the dimension limits tab, you can tick Show Others which will sum all dimensions excluded by the limit into a value named Others. You can click on the Others bar to drill into the dimensions it contains.

Re: Bar Chart

stevedark — Tue, 14 Jan 2014 08:33:08 GMT

In order to achieve what you are asking you would need to have the aggregated values as dimensions. To do that you would need to have a RESIDENT load with a GROUP BY in your load script. You could then have a chart that has the value as the dimension as well as being part of the expression. You would then have to switch out the chart that showed the values on the Y and the X axis for a chart showing the actual dimensions and each of the bars when a single value was selected. You could do this with either a show condition something like GetPossibleCount(AggregatedValue) = 1 on one chart and GetPossibleCount(AggregatedValue) <> 1 on the other, or perhaps a calculated dimension where based on the GetPossibleCount or or other dimension is used.

That said, I would suggest that this may not be the best idea, and Dimension Limits are the recommended approach (as Colin suggests) for shrinking the number of bars. I could see that perhaps that a bar that shows that the sum of all the 2's is actually larger than just one instance of 150.

You could probably achieve the same with a calculated dimension using the Aggr function - but calculated dimensions are inherently slower than actual fields - particularly when you start doing aggregations and calculations in them.

Hope that helps.

Steve

Re: Bar Chart

sujeetsingh — Tue, 14 Jan 2014 08:36:46 GMT

Go for using the Dimension limits