Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pepe2209
Creator
Creator

Bug in "Suppress Zero-Values" SR13?

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:

1.PNG

the server (Qlikview 11.2 SR13) shows this:

2.PNG

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

15 Replies
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
Partner
Partner

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

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

pepe2209
Creator
Creator
Author

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

Capture.PNG

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

pepe2209
Creator
Creator
Author

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
Creator
Creator
Author

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)