NULL values in the Pivot Table

[#1]

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.

[avinashelite]

can you please share your app

[amit_saini]

Hi Gayan,

Check:

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

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

Thanks,

AS

[avinashelite]

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

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