topic Re: Bar chart too wide gap in QlikView

Bar chart too wide gap

asamariaekrickl — Sat, 16 Nov 2024 03:12:46 GMT

Hi there,

I have created a bar chart with FinancialYear as the dimension and two expressions showing current year and previous year.

The problem is the big gap between the bars and that the bars are at each side of the chart.

Do you have any idea what might cause this gap?

Re: Bar chart too wide gap

ramasaisaksoft — Mon, 24 Jun 2019 14:13:46 GMT

Hi,

we can custom bar distance by options like

Re: Bar chart too wide gap

asamariaekrickl — Tue, 25 Jun 2019 01:04:21 GMT

Thanks, but I have tried all those without success.

Asa

Re: Bar chart too wide gap

jonathandienst — Tue, 25 Jun 2019 05:35:43 GMT

This looks like two bars per year, with the 'wrong' year evaluating to zero, so there are two zero bars in the middle. If you provide more information (or preferably a small sample qvw illustrating the problem), then you will get suggestions on how to remove the extra zero bars.

Re: Bar chart too wide gap

asamariaekrickl — Tue, 25 Jun 2019 06:02:44 GMT

Hi,

I'm sorry I can't share a sample qvw unfortunately.

There are two expression:

Expression 1
avg({<[Performance Indicators / Measures]=, YTD=, QTDLQ=, MTDLM=, FinancialYear=,[FY Year Number] = {'$(=$(vMaxFYYear-1))'}>} [KPI Value])

Expression 2
avg({<[FY Year Number] = {'$(=$(vMaxFYYear))'}>} [KPI Value])

Variables
max(right(FinancialYear,2)-1)
and
max(right(FinancialYear,2))

FY Year Number is

If you have any ideas how to remove these extra bars, that would be amazing.

Asa

Re: Bar chart too wide gap

anushree1 — Tue, 25 Jun 2019 07:23:55 GMT

Can you Try creating the same chart using straight table that would help us check if there are any years in between with 0 or 0.000789 kind of values and then treat the situation accordingly

Re: Bar chart too wide gap

asamariaekrickl — Tue, 25 Jun 2019 08:24:06 GMT

No clues there I'm afraid

A clue though is that this is gap is happening in all charts in this app. And there are a few... 🙂

Re: Bar chart too wide gap

anushree1 — Wed, 26 Jun 2019 11:17:05 GMT

the issue here is that 2 expressions are used and one of them is null whereas the other has value thus an empty placeholder for the Null expression gets created, try using a single expression and that will help you understand the cause better