topic Re: Conditional Cell Color in Pivot table if Column Header and Row Header names in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Chanty4u — Mon, 19 Mar 2018 16:46:35 GMT

try

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

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

Chanty4u — Mon, 19 Mar 2018 16:47:43 GMT

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

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

Anonymous — Wed, 21 Mar 2018 13:26:00 GMT

Thanks !! it works ...

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

Chanty4u — Wed, 21 Mar 2018 13:28:10 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful