topic Re: Bar Chart - Bar for 0 value in QlikView

Bar Chart - Bar for 0 value

venkat_thota — Tue, 29 Jan 2019 21:00:46 GMT

Hi,

I found this weird behavior in Bar Chart. When the value is zero then it shouldn't show the bar as the axis is 0. But its showing the Bar (Enclosed the screenshot). I understand the reason why because its a taking the decimal values. Though the data value showing as 0% , the actual value is 0.00476. This creates confusion for users.

Is there any fix for it?

Re: Bar Chart - Bar for 0 value

mikaelsc — Tue, 29 Jan 2019 23:15:28 GMT

Floor() your expression if you want 0.

if you want to show the actual value,increase decimals...

Re: Bar Chart - Bar for 0 value

jonathandienst — Wed, 30 Jan 2019 05:52:49 GMT

Floor(your expression, 0.01)

Round(your expression, 0.01)

Re: Bar Chart - Bar for 0 value

venkat_thota — Wed, 30 Jan 2019 14:58:33 GMT

If I use round or floor function in expression, it gives wrong result, the percentage wont come correct. all I wanted to do is bar should be in sync with data value.

If the expression returns 0.072, it should consider as 1% and the bar also should show accordingly.

If the expression returns 0.035, it should consider as 0% and the bar also shouldn't show.

if the expression returns 0.1245, it should consider as 13% and the bar should show accordingly.

My problem is data value is showing correct, but not the bar.