topic Re: Hide empty bars in chart in QlikView

Hide empty bars in chart

AjosefMD — Wed, 16 Oct 2019 05:57:55 GMT

Dear all,
I have a issue with a bar-chart. In my example I have two Dimensions
- Department
- Code

and Expression
- Count(ID).

Result is a bar-chart with empty bars for Departments, because not all Departments have the same codes.

Please find attached a example. How can I hide this NULL-bars?

Thanks in advance,
Josef

Re: Hide empty bars in chart

Victor_Alumanah — Wed, 16 Oct 2019 09:06:45 GMT

You can go in to the properties and change it to a Stacked bar chart.

Re: Hide empty bars in chart

AjosefMD — Wed, 16 Oct 2019 09:14:57 GMT

For my main application I can not use stacked bar Chart, because there are many different Codes...

Re: Hide empty bars in chart

Victor_Alumanah — Wed, 16 Oct 2019 10:14:44 GMT

I have come across this issue before but never found a solution without stacking it. another option if your data is not large would be the diagram(Grid chart) below, not the ideal i know but I have included it in case it works for someone else.

Re: Hide empty bars in chart

Brett_Bleess — Tue, 22 Oct 2019 15:34:29 GMT

The best I have to try to explain things is something I grabbed from the Help:

"If this check box is marked, all combinations of the dimension fields associated with only null values in all fields in all expressions will be disregarded in the calculation. This option is selected by default. Turning it off can be useful only in special cases, e.g. if you want to count null values in a chart."

The underlying issue is that all of the dimensions across the expression are not null, only some, therefore the nulls are not suppressed. Per the other poster, I am not aware of a means to change this behavior, believe you would have to work on the data model somehow to accommodate things. Maybe one of the folks that is a better developer than am I can expand further here.

Regards,
Brett