topic Re: Handling nulls in charts in QlikView

Handling nulls in charts

deepakqlikview_123 — Tue, 10 May 2016 17:35:15 GMT

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

Re: Handling nulls in charts

sunny_talwar — Wed, 11 May 2016 01:29:34 GMT

I would be curious to learn about this as well

Re: Handling nulls in charts

deepakqlikview_123 — Wed, 11 May 2016 03:56:26 GMT

Hi All,

Is there any way to get such functionality in qlikview.

Thanks,

Re: Handling nulls in charts

Anonymous — Wed, 11 May 2016 04:10:33 GMT

in script give the condition like this way be it is solve in the if(field name <>null) as field name than may be you get it

Re: Handling nulls in charts

marcus_sommer — Wed, 11 May 2016 04:55:39 GMT

I don't believe that it will be possible to change these property without a macro. I think you should rather consider a different approach to handle NULL within these datamodel by eliminating a few types/occurrences of NULL's and replacing them with real values like '#NV'. See for this: NULL handling in QlikView.

- Marcus

Re: Handling nulls in charts

jonathandienst — Wed, 11 May 2016 05:04:25 GMT

One way without macros is to create 2 copies of the chart - one with suppress on and another with the setting off. Then use a variable to control visibility (expression in the Layout tab). You can add one or two buttons to control the value of the variable. Although I would first consider replacing the nulls as mentioned by Marcus.

Re: Handling nulls in charts

deepakqlikview_123 — Wed, 11 May 2016 06:12:20 GMT

Hi Marcus,

Can you please suggest how applying condition will work in data model and at chart level.

Thanks,

Deepak

Re: Handling nulls in charts

Wed, 11 May 2016 06:24:01 GMT

Yes,

As mentined by Jonathan

I think without macros

There only two possible ways to handle nulls in your case

One is handling in script another one is make copy all charts and place with enabling suppress null value option then control visibility of one format charts with variable

Re: Handling nulls in charts

deepakqlikview_123 — Wed, 11 May 2016 13:32:25 GMT

If possible ,Can you please share sample example on this

Re: Handling nulls in charts

marcus_sommer — Wed, 11 May 2016 13:36:46 GMT

What do you mean with "applying condition"?

- Marcus

Re: Handling nulls in charts

deepakqlikview_123 — Wed, 11 May 2016 13:55:58 GMT

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.

Re: Handling nulls in charts

marcus_sommer — Wed, 11 May 2016 14:15:18 GMT

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

Re: Handling nulls in charts

deepakqlikview_123 — Tue, 05 Jul 2016 07:45:37 GMT

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

Thanks