Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

antonybi
New Contributor III

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

Tags (1)
12 Replies
Chanty4u
Esteemed Contributor III

Re: pivot table issue

uncheck this

hand.PNG

antonybi
New Contributor III

Re: pivot table issue

Yes I did but not working!!!

Still its showing the same.

snap2.PNG

Kindly suggest whats wrong with this???

Chanty4u
Esteemed Contributor III

Re: pivot table issue

try this

full.PNG

antonybi
New Contributor III

Re: pivot table issue

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
Esteemed Contributor III

Re: pivot table issue

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
New Contributor III

Re: pivot table issue

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
Esteemed Contributor III

Re: pivot table issue

am not sure  about that. Need to check

antonybi
New Contributor III

Re: pivot table issue

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
Contributor

Re: pivot table issue

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

Community Browser