pivot table issue

[antonybi]

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.

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!!!

[Chanty4u]

uncheck this

[antonybi]

Yes I did but not working!!!

Still its showing the same.

Kindly suggest whats wrong with this???

[Chanty4u]

try this

[antonybi]

Yes that's fine...

But when we select expand all it was showing gray colour(as I shown in above snapshot) for null values.

How do we remove gray colour in this scenario...

or can you suggest any alternate solution/extension on the same.

kindly help

[Chanty4u]

the result is coming based on dimensions

for example:

Oil --brown--- you dont have value for Large  type thats why it is  giving grey[Null value]   so like the same way all

[antonybi]

Yes agreed with you!!

Is there any way to show white colour as customer don't want to see this default colour(grey) ???

can we write any expression for this or any other extension..

[Chanty4u]

am not sure  about that. Need to check

[antonybi]

Chanty have you got any solution for this??

This is the client requirement can somebody help me to achieve this requirement by suggesting any other alternate solution/extension.

In Qlikview, we don't have any issue and it is working perfectly.

PFB for your reference.

I just wanted to check whether its possible or not in qliksense???

[saniyask]

Hi Antony,

Its the default background color for null values in Qlik Sense , I don't think its possible to change via any expression.

Regards,

Saniya