topic Re: Bar Chart Issues in QlikView

Bar Chart Issues

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

Hi All,

In the attached bar chart, From Oct16 to Feb17,

1 --> I need to remove the empty space between the bars

2 --> For entire chart Gray colour bar i need to decrease the width. Like bars.png image

Could you please help me on these two issues.

Re: Bar Chart Issues

avinashelite — Mon, 24 Apr 2017 07:52:23 GMT

Are you conditional hiding of your expressions ? or does you expression does not yield any results ? check this , if still face any issues share the app

Re: Bar Chart Issues

Anil_Babu_Samineni — Mon, 24 Apr 2017 08:00:28 GMT

May be this? Check same for increase Bar size using the BAr Distance

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 08:34:37 GMT

Hi, We don't have any data for prior months. So, that it was giving null space between the bars.

The data and the results seems to be good. I need to do format the layout.

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 08:37:09 GMT

Hi I have tried the above property.

Still the layout seems to be same as previous. I hope cluster distance will increase/decrease the space between two different dates data. But in this case, with in the single date only we need to remove the space.

Re: Bar Chart Issues

avinashelite — Mon, 24 Apr 2017 09:07:31 GMT

Share you app

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 09:26:24 GMT

Hi Avinash,

I cann't upload the Original, For your reference i have created a sample app with less data. Please find the same as attached.!

Re: Bar Chart Issues

Anil_Babu_Samineni — Mon, 24 Apr 2017 09:44:06 GMT

Is this you are expecting

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 09:50:05 GMT

No, I need to remove the empty space between the in Oct16 bar. Highlighted the same in Red below attached image.

Re: Bar Chart Issues

Anil_Babu_Samineni — Mon, 24 Apr 2017 09:54:17 GMT

I think, The same in my response, Right?

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 09:59:11 GMT

No Anil Babu,

You have decreased the cluster distance, that will decrease the space between the two dimension fields.

But, I am asking about in a single dimension field, One of the expression data is coming as Zero. If i click on Supress Null values, It was showing as empty space between the other bars. For example if you see, Apr17 we have all 4 expression bars, but in the oct 16 we are missing the third bar for that it was showing empty space.

I need to remove that space from the chart.

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 10:29:18 GMT

Guys,

At least any idea on 2nd point, bit urgent. Can you please help me in this regard.

Re: Bar Chart Issues

avinashelite — Mon, 24 Apr 2017 10:34:47 GMT

I think we don't have any direct way to do this , the zero value bar are showing up in that blank space and since its from multiple expression it will be shown as the blank space ......

One way is to show the value on data points so that it will show as 0 bars

we need to club all the expression and then handle based on the condition

Re: Bar Chart Issues

Anil_Babu_Samineni — Mon, 24 Apr 2017 10:37:47 GMT

1) I don't think whether we have control for that due to you have hidden space bars

2) The only way you have is increase the width of the chart (As i know). Because, we have option for decrease the width for all metrics but not the specific metric.

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 10:38:13 GMT

Ok.

Thanks Avinash for update on point1. can you please respond to the 2nd point i.e. we need to decrease the bar width for only single expression. Is this possible in QV.

Re: Bar Chart Issues

ashok1203 — Mon, 24 Apr 2017 10:39:12 GMT

Thanks Anil.