topic Re: NULL values in the Pivot Table in QlikView

NULL values in the Pivot Table

Thu, 05 Feb 2015 10:37:59 GMT

Hi All,

I have a weird problem which I hope someone would be having a solution to. I have a pivot table which gets its dimension from an excel file and the values are populated from the SQL. The table works perfectly until if there are no values in the resultset. When this happens an additional column is created with a '-'. This is so annoying.

I've tried the following:

Ticking the 'Surpress when value is Null'
Ticking the 'Surpress Zero values'

But none of those have helped.

Thanks,

Gayan.

Re: NULL values in the Pivot Table

avinashelite — Thu, 05 Feb 2015 10:41:26 GMT

can you please share your app

Re: NULL values in the Pivot Table

amit_saini — Thu, 05 Feb 2015 10:42:15 GMT

Hi Gayan,

Check:

http://community.qlik.com/message/536926#536926

http://community.qlik.com/message/600841#600841

Thanks,

Re: NULL values in the Pivot Table

avinashelite — Thu, 05 Feb 2015 10:42:36 GMT

The additional column is because of Total of the expression I guess.

go to expression tab>go to >total mode and select no total