Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

pivot table issue

Hi,

I have created pivot table with

Rows-->Product

Rows---> Category

and

column--->Type

and

measure--> Sum(Sales)

after, it is showing as below snapshot.

snap1.PNG

So here, help me to remove the gray colour as it is too much irritating.I want to show it in white colour.

any help will be appreciated..

Thanks in advance!!!

PFB for your reference!!!

12 Replies
Highlighted
Creator
Creator

Yes yes...I agreed.

can we find any other extension to accomplish this or by editing Jscript??

Highlighted
Champion III
Champion III

i dont think so as of now no.

Highlighted
Creator
Creator

You could try to use an outer join in your load script and then use something life if(isnull(value), 0, value) so that the null values are 0's instead of nulls.  That will make all those areas show in white with a 0 instead of grey with a '-'. It will greatly expand the size of your data model, but if it isn't large to begin with maybe that is acceptable.