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

[#2]

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)

[sunny_talwar]

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.

[pepe2209]

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

[swuehl]

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.

[sunny_talwar]

Good to know this for future reference

[pepe2209]

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.