topic Re: Suppress Zero-Values Chart QlikView to QlikSense in App Development

Suppress Zero-Values Chart QlikView to QlikSense

mmj3 — Tue, 17 Aug 2021 17:45:49 GMT

Hello,

I am in the process of converting some of my QlikView files to QlikSense.

One of my reports in QlikView uses a great deal of line charts, with the Suppress Zero-Values option.

I can not find an option that replicates this like QlikView does. Anybody know where this exists?

I have attached a screenshot of what I am referring to in QlikView.

Re: Suppress Zero-Values Chart QlikView to QlikSense

Vegar — Tue, 17 Aug 2021 19:05:10 GMT

It is found in the Add-ons section of the properties section.

Re: Suppress Zero-Values Chart QlikView to QlikSense

mmj3 — Tue, 17 Aug 2021 19:34:35 GMT

@Vegar I appreciate the response! However, this does not work. Please see the snapshot provided below. Every dip is a 0 value.

Re: Suppress Zero-Values Chart QlikView to QlikSense

Vegar — Wed, 18 Aug 2021 06:47:18 GMT

Strange. You might also need to adjust how you present missing values in the Apperance-Presentation object property pane. In the third graph in my sample below I've set the sow missing as connections.

I am also attaching my sample qvf file.

Re: Suppress Zero-Values Chart QlikView to QlikSense

mmj3 — Wed, 18 Aug 2021 11:52:51 GMT

@Vegar Using an if statement to make the zeros null, combined with the changing the Missing Values to connections worked! Thanks again!