This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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
if you try without the null() do you have the same result ?
The Dimension option "Suppress when value is Null" is also checked so "Show All Values" is not checked
Have you searched the community for similar threads like this? It may very well be a bug.
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
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.
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.
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.
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)