Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
Not applicable

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

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

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

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.