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

bertrand_herard — Fri, 27 Apr 2018 09:44:14 GMT

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

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

marcus_sommer — Fri, 27 Apr 2018 11:07:39 GMT

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

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

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

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