Handling nulls in charts

[deepakqlikview_123]

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

[sunny_talwar]

I would be curious to learn about this as well

[deepakqlikview_123]

Hi All,

Is there any way to get such functionality in qlikview.

Thanks,

[Anonymous]

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

[marcus_sommer · Accepted solution]

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

[jonathandienst]

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.

[deepakqlikview_123]

Hi Marcus,

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

Thanks,

Deepak

[#8]

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 

[deepakqlikview_123]

If possible ,Can you please share sample example on this

[marcus_sommer]

What do you mean with "applying condition"?

- Marcus