topic Re: why Null Dimension is displaying when data is not there ? in QlikView

why Null Dimension is displaying when data is not there ?

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

Hi All,

I have Bar chart and Line chart in my Dashboard.

I have dimension ad date and Expression as Count of Asset Id

So whenever i clicked on the bar chart automatically line chart also reflecting but here in the line chart doesn't have data and end of the dimension i can on '- ' in dimension so why it is displaying

how to avoid the '-' as dimension value

we have applied axis grid so it is showing all dimension values without data also along with all dimension values one more Null value also coming in the dimension why it is comming How to remove it????

Note: I have applied in Dimensions tab and Presentation tab Supress when value is Null and Supress Missing

Please help in this

Thanks in Advance

Re: why Null Dimension is displaying when data is not there ?

sergio0592 — Mon, 15 Jul 2019 08:16:44 GMT

Hi,

In dimension tab, check "Supress when value is null" and in presentation tab, check "Supress zero value".

Re: why Null Dimension is displaying when data is not there ?

Brett_Bleess — Wed, 07 Aug 2019 19:05:09 GMT

Narayana,

Could you potentially attach a reduced version of the app, so we can have a direct look at things? If you did get things sorted, you can post what you did, and then mark that as the solution as well by clicking the Accept as Solution button. If you cannot attach your current app, if you could do a sample app that shows the issue as well, that would work too.

The only other thing of which I can point to is the following links:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullValue.htm

https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674

Regards,
Brett