Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
bertrand_herard
Partner - Contributor III
Partner - Contributor III

Suppress Zero Values doesn't work in CrossTable with First function

Hi guys,

I've a strange problem with QlikView 11 SR13.

I'm using a Cross Table with 5 dimensions (4 in columns and 1 in lines).

My Expressions is something like :  Calculation / First(Calculation) (I'm dividing the current column by the first column).

In the dev environment All is OK (QlikView 11 SR16).

In the Production environment (QlikView 11 SR13), the Suppress Zero Values and Suppress missing doesn't work anymore (My table always displays a huge number of empy lines and empty columns). The point seems to be the usage of the function first in QlikView SR13 (I'm forced to use this, I cannot use set analysis to handle due to the formula).

Does somedy know how to workaround this ?

Best regards

1 Reply
marcus_sommer

One point could the different releases be that there is any incompatibility ... At first I would rebuild the object from the scratch (copy & paste from the expression-strings is ok. but no copying of any properties). If this don't work I would check if the data have changed and maybe values which are in one environment are NULL are now 0 or empty within the other or something similar.

- Marcus