topic Re: Suppress null values in dimensions in QlikView

Suppress null values in dimensions

Sun, 08 Dec 2013 11:58:05 GMT

Hi all,

This is my case:

As you can see, I have missing value after run_id 13 that I don't want to put on the chart.

but if I remove the suppress when value is null then I get data shown regarding this missing run_id which shouldn't be shown.

if I remove the Show all values then I don't get any data regarding any run.

How can I show data regarding all the RUN_ID which are not NULL even if the expression regarding them is Zero?

Thanks,

Boris

Anonymous — Sun, 08 Dec 2013 12:02:08 GMT

Boris

On the chart Presentation tab untick Suppress Zero-Values whilst leaving the Dimension Suppress When Value Is Null ticked.

Best Regards, Bill Markham

Sun, 08 Dec 2013 12:08:24 GMT

Helped for other charts, in this one I get the same situation as in the print screen.

This is the presentation tab of this chart

Anonymous — Sun, 08 Dec 2013 12:54:13 GMT

Boris

Try unticking the Suppress Missing as well.

Best Regards, Bill

Sun, 08 Dec 2013 12:58:12 GMT

Doesn't help.

it's quite critical for me..

Anonymous — Sun, 08 Dec 2013 14:35:27 GMT

Boris

Curious, would you be able to share a sample qvw ?

Best Regards, Bill

Sun, 08 Dec 2013 14:45:41 GMT

how can I create a sample?

Anonymous — Sun, 08 Dec 2013 15:40:14 GMT

Boris

This post Preparing examples for Upload - Reduction and Data Scrambling by robwunderlich gives good advice re any file size and data privacy.concerns you may have about uploading an example file.

Best Regards, Bill

Sun, 08 Dec 2013 20:29:31 GMT

Boris, you can try change the missing values to "0", and then Supress Zero-Values as Bill explained.

Try this options:

Best Regards,

Anderson