Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
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
Chanty4u
MVP
MVP

uncheck this

hand.PNG

antonybi
Creator
Creator
Author

Yes I did but not working!!!

Still its showing the same.

snap2.PNG

Kindly suggest whats wrong with this???

Chanty4u
MVP
MVP

try this

full.PNG

antonybi
Creator
Creator
Author

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

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
Creator
Creator
Author

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

am not sure  about that. Need to check

antonybi
Creator
Creator
Author

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.

Capture1.PNG

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

saniyask
Creator
Creator

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