Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I would be curious to learn about this as well
Hi All,
Is there any way to get such functionality in qlikview.
Thanks,
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
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
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.
Hi Marcus,
Can you please suggest how applying condition will work in data model and at chart level.
Thanks,
Deepak
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
If possible ,Can you please share sample example on this
What do you mean with "applying condition"?
- Marcus