topic Pivot Table in QlikView

Pivot Table

Thu, 07 Jun 2012 09:31:15 GMT

I have 3 expression with multiple dimension in a pivot table. The first 2 expression columns are just normal sum where third column is the result of column(1) - column(2).

I have an issue where sometimes even the column(1) -column(2), I will get -0.00. I am pretty sure the values for both column 1 and column 2 are same but mostly, it will shows 0.00 (which is what i need) but occasionally it is showing -0.00. There is no decimal values for these figures.

I am using QV9 SR2. Is this a bug or there is some workaround to show 0.00 for all zeroes?

Pivot Table

Miguel_Angel_Baeyens — Thu, 07 Jun 2012 09:48:08 GMT

Hi and Welcome!

First, is it possible that the real number is for example -0,00001 but you are rounding to two decimal positions and therefore the difference?

Note that Support for QlikView 9 is coming to an end. You may think of upgrading to version 10 or 11. Anyway, I'd recommend you to upgrade to version 9 SR7 (latest release of version 9 build 7808) to check if that keeps happening. If so, contact support@qlik.com with as much data as you can so they can provide the more accurate answer possible.

Hope that helps.

Miguel

Pivot Table

Thu, 07 Jun 2012 09:54:15 GMT

Unfortunately, even i look deeper into 20 decimals, value still the same. I dont think we can upgrade to other version beside version 9 since our server is only 9 and no point to have objects that server cant support.

Will give a try of other version/SR to confirm if this.

thanks.

Pivot Table

Thu, 07 Jun 2012 16:03:10 GMT

As a work around you can include an if statement:

if(sum(column(1) -column(2)) = -0.00, fabs(sum(column(1) -column(2)))

This will return the absolute value of -0.00