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
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
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)