Bug in "Suppress Zero-Values" SR13?

[pepe2209]

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

[sunny_talwar]

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

[qlikvfpi]

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

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

[pepe2209]

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

[sunny_talwar]

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

[sunny_talwar]

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

[pepe2209]

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.

[sunny_talwar]

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.

[pepe2209]

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.

[sunny_talwar]

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)