topic Re: How to remove null valued dimension in a bar chart ? in QlikView

How to remove null valued dimension in a bar chart ?

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

Hi Techies,

In a bar chart I have Month_Yr as first dimension and Client as second dimension. Also I have 3 expressions.

For Example:

I have 5 clients as A, B, C, D, E.

In the Month_Yr : Apr_16 , we have only C as client. But in bar chart for Apr_16 it displays all the clients. Here I want to show only C for Apr_16.

Likewise across all Month_Yr only available clients should come !...

How to achieve this.

Regards,

Rangaraju.

Re: How to remove null valued dimension in a bar chart ?

vvvvvvizard — Tue, 30 Aug 2016 14:21:33 GMT

In the Dimensions tab , try selecting the "Supress when value is null " checkbox

Re: How to remove null valued dimension in a bar chart ?

rajuamet — Tue, 30 Aug 2016 14:26:22 GMT

Hi Yusuf, no it did not help. It wont suppress.

Re: How to remove null valued dimension in a bar chart ?

jpenuliar — Tue, 30 Aug 2016 14:46:27 GMT

Hi Rangaraju,

you have 3 expressions in your chart where at least 1 expression returns value <> 0. suppression will not work as you would have expected. try maybe splitting your chart to 3(for each expresssion) or try another type of chart (Straight Table)

Re: How to remove null valued dimension in a bar chart ?

vishsaggi — Tue, 30 Aug 2016 14:58:03 GMT

would something like this works ?

If yes, just add Client field in expression tab and uncheck bar and check text on axis.

Re: How to remove null valued dimension in a bar chart ?

rajuamet — Tue, 30 Aug 2016 15:05:15 GMT

Hi Jonathan,

If at least 1 expression returns value <> 0 , then bar is displayed for that expression. Which is fine. I need to show that bar.
Even if I split the chart to 3 (for each expression) I am getting null dimensions.
In straight table expected result is achieved. But the requirement is Bar chart!!!

Re: How to remove null valued dimension in a bar chart ?

rajuamet — Tue, 30 Aug 2016 15:11:53 GMT

Hi Vish,

Close enough, but how do I remove the uneven gaps!

Re: How to remove null valued dimension in a bar chart ?

rajuamet — Tue, 30 Aug 2016 15:20:27 GMT

Hi Vish, Can you share your app.

My output is something like this... Client text on axis is not proper... How did you do that..

Re: How to remove null valued dimension in a bar chart ?

vishsaggi — Tue, 30 Aug 2016 15:26:03 GMT

Removing the gaps I am not sure, the one which i gave you is just a work around.

PFA.

Re: How to remove null valued dimension in a bar chart ?

rajuamet — Wed, 31 Aug 2016 05:04:07 GMT

Hi Vish,

When I opened ur app, the chart is displayed like below:

See the Axis tests. It is not pinned in proper place. The image which u sent earlier displays the axis texts properly. How did you achieve that.

Re: How to remove null valued dimension in a bar chart ?

Wed, 31 Aug 2016 06:43:57 GMT

Hi Rangaraju,

As per my understanding, Axis text is showing properly in the middle only, But in Mar_16 dont have values for clients B,C,D,E thats why it looks that.

In Feb_16 we have all the values thats where u can see axis values in the middle.

Re: How to remove null valued dimension in a bar chart ?

vishsaggi — Wed, 31 Aug 2016 12:55:37 GMT

That is strange. I have just downloaded the same app i sent you earlier. It is displaying this

are you doing any changes in axes or presentation tab ?

Re: How to remove null valued dimension in a bar chart ?

rajuamet — Wed, 31 Aug 2016 13:04:49 GMT

No, I did not change anything. Will it be due to different versions??? I am using QlikView 11.20 SR5.

Re: How to remove null valued dimension in a bar chart ?

vishsaggi — Wed, 31 Aug 2016 13:16:34 GMT

Could be possible, i am not pretty sure if it is with the version. Mine is QV11.20 SR12.