Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
But none of those have helped.
Thanks,
Gayan.
can you please share your app
Hi Gayan,
Check:
http://community.qlik.com/message/536926#536926
http://community.qlik.com/message/600841#600841
Thanks,
AS
The additional column is because of Total of the expression I guess.
go to expression tab>go to >total mode and select no total