Conditional Cell Color in Pivot table if Column Header and Row Header names

[Anonymous]

Hi

I created Pivot table object to perform weekly status comparison. However, I want format cell  within pivot table based on the status names in Row and Column. For example, in below chart where LW.Status A = TW.Status A  , I would like to format cell background colour or font colour.

                                         This Week

Last week        TW.Status A    TW.Status B   TW.Status C

LW.Status A        80                     2                     3

LW.Status B                                 30                     6

LW.Status C         2                       1                    45

Let me know if it is not clear and I'll try to provide further clarification.

Any help would be highly appreciated !!

[Chanty4u]

try

if(lw.status=twstatusA,blue())

[Chanty4u]

or

You can directly go to 'Chart Properties'  inside that 'Visual Cues', there you can directly set your range for Cell Background and Text colour also

[Anonymous]

Thanks !! it works ...

[Chanty4u]

Nice please close the tread by making correct and helpful answers.

Qlik Community Tip: Marking Replies as Correct or Helpful