topic Re: Bug in "Suppress Zero-Values" SR13? in QlikView

Bug in "Suppress Zero-Values" SR13?

pepe2209 — Fri, 08 Apr 2016 12:50:54 GMT

Hello All,

I have opened exactly the same application with the same selections on my local desktop and on our companie server:

my local desktop (Qlikview 11.2 SR5) shows this:

the server (Qlikview 11.2 SR13) shows this:

The expression of the graph is:

if(sum(NoRecords)>=vMinRecords, sum(A)/sum(B), null())

So when the min no. of records is not reached the expression result is null()

The option "Supress Zero-Values" is checked.

Why does SR13 still show the empty values?? is this a bug.

Some help would be appreciated.

Regards,

Peter

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 12:53:36 GMT

Do you happen to have 'Show All Value' Checked on the dimension tab may be? I guess it still doesn't explain why it works on your machine and not on the server. If you can share your app or a sample, I can test on QV 12

Re: Bug in "Suppress Zero-Values" SR13?

qlikvfpi — Fri, 08 Apr 2016 12:54:47 GMT

if you try without the null() do you have the same result ?

if(sum(NoRecords)>=vMinRecords, sum(A)/sum(B))

Re: Bug in "Suppress Zero-Values" SR13?

pepe2209 — Fri, 08 Apr 2016 12:56:54 GMT

The Dimension option "Suppress when value is Null" is also checked so "Show All Values" is not checked

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 13:00:13 GMT

Have you searched the community for similar threads like this? It may very well be a bug.

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 13:02:27 GMT

Check this link (Page 11) -> http://download.toccato.com.br/Personal/QlikView%2011.2%20build%2013206%20SR13%20Release%20Notes.pdf

I don't know how this impact, but may be related to the issue you are seeing

Re: Bug in "Suppress Zero-Values" SR13?

pepe2209 — Fri, 08 Apr 2016 13:12:33 GMT

Thanks, This is probably related to my issue.

There are options for me to work around this problem so I am going to do that.

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 13:15:25 GMT

Yup, One option would be to make the dimension null when your expression is null and then you already have Suppress When Value Is Null selected.

Re: Bug in "Suppress Zero-Values" SR13?

pepe2209 — Fri, 08 Apr 2016 13:23:58 GMT

Yes exactly, but i can't put a sum() calculation in the dimension so i will have to do this calculation first in the script.

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 13:26:08 GMT

You can. Try using a calculated dimension like this (replace DimensionName with your current Dimension)

Aggr(If(Sum(NoRecords) > 0, DimensionName), DimensionName)

UPDATE: made a mistake in the if condition. Fixed it based on Dathu's response

Aggr(If(Sum(NoRecords) > vMinRecords, DimensionName), DimensionName)

Re: Bug in "Suppress Zero-Values" SR13?

Fri, 08 Apr 2016 13:34:45 GMT

This is the calculated Dimension expression:

IF( Aggr(Sum(NoRecords),DimensionName) > vMinRecords , DimensionName)

and expression Would be: Sum(A)/Sum(B)

But you can try direct expression I guess:

Sum({DimensionName={"Sum(NoRecords)>$(vMinRecords)"}} A)/Sum({DimensionName={"Sum(NoRecords)>$(vMinRecords)"}} B)

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 13:38:02 GMT

I guess the issue with the expression is that the QV 11.20 SR13 is not suppressing zero values. So I believe the expression version will have the same issue.

Re: Bug in "Suppress Zero-Values" SR13?

pepe2209 — Fri, 08 Apr 2016 13:41:49 GMT

I just discovered the difference is not created by the main expression or dimension. The expression for background color of the bars is the reason!
I used an expression for coloring the bars which involves RowNo(). This is the cause of the bug.

Here is a simple example which is not displayed correctly in SR13

Re: Bug in "Suppress Zero-Values" SR13?

swuehl — Fri, 08 Apr 2016 13:43:45 GMT

That's not a bug, it's documented in the HELP:

Chart inter record functions

These functions can only be used in chart expressions.

Note!
Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when Chart Inter Record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.

Suppression of zero values is automatically disabled when these functions are used.

See Examples of Chart Inter Record Functions.

Re: Bug in "Suppress Zero-Values" SR13?

sunny_talwar — Fri, 08 Apr 2016 13:47:05 GMT

Good to know this for future reference

Re: Bug in "Suppress Zero-Values" SR13?

pepe2209 — Fri, 08 Apr 2016 13:51:15 GMT

Thanks

This is also noted in the HELP of SR5 and there it does surrpress the zero values. in SR13 it doesn't so either way one of them contains a bug.