Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Handling nulls in charts

Hi All,

. I have around 50 charts in one application.  Few charts have supress zero l value enabled . Few charts have supress zero value disabled. Now requirement is : we need one options/ toggle/setting  which can disable or enable supress value option for full document for all the charts so that we dont need to go to all the charts separately . We can not use macro for this. Need to find a solution though some settings or something like that.

Thanks

12 Replies
deepakqlikview_123
Specialist
Specialist
Author

I understood how it works after overlapping objects one is for null and other one is for non null values.

In second way I have replaced null values in dimension with some other value but not able to understand how it works for  fulfilling our current requirement.

marcus_sommer

Unfortunately I couldn't say exactly what you need to do to get your desired views. There will be reasons on the data combined with particulary requirements to display the data within one object which had led to the decision to enable or disable the NULL view within the objects. I do not know them. But if you replaced certain NULL's with real values you will be able to react more flexible on them within your expressions. You could include/exclude certain or all of them, for example within a set analysis to get what you need.

It could be that you need to redesign many of your objects and it will cost you some efforts (but I hadn't promised that it will be easy and fast).

- Marcus

deepakqlikview_123
Specialist
Specialist
Author

it has been achieved by use same dimension 2 times use conditional enabling one with suppress null and other without using suppress null.

Thanks