Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

My pivot table some row display white , How to make whole table in one color ?

Hi All

My pivot Table when 1st column have not data , the whole row will be white. this make the table look not perfect. Hope some one can advise me how to make whole table white or yellow ?

1 Solution

Accepted Solutions
buzzy996
Honored Contributor II

Re: My pivot table some row display white , How to make whole table in one color ?

see below,tht;s causing issue.for.png

3 Replies
marcus_malinow
Valued Contributor III

Re: My pivot table some row display white , How to make whole table in one color ?

If you right-click the white cell, and select custom format. Then change it to yellow like the others.

See attached.

buzzy996
Honored Contributor II

Re: My pivot table some row display white , How to make whole table in one color ?

see below,tht;s causing issue.for.png

paulyeo11
Valued Contributor II

Re: My pivot table some row display white , How to make whole table in one color ?

Hi Marcus

After looking at your solution , i like it , and i think it is better solution , as i still can keep my old code which will be use for other none pivot table.

Thank you for your help.

Paul