Cell colors overwrite in Pivot

[Anonymous]

Hi All

I need color to overwrite with below condition

All row color should follow the pattern Green -> Amber -> Red -> Black

For above example I need as below

Zone  MB1  MB2  MB3  MB4

East   G       B       B       B   --> Amber should turn to Black for MB3 & MB4

West  R       R       R       R  --> Amber & Green should turn Red because pattern Green Amber Red Black

North  B       B       B       B   --> All blacks

South A       R       R       R   --> After Red no Amber allowed for MB3 & MB4

I have attached TestRAG.QVW. For back ground color I have created variables

Thanks in advance for your valuable suggestion

[Anonymous]

Hi Vijay

It works, Thanks for your efforts

Thanks again

[Anonymous]

Thanks Vijay

[vvira1316]

You are welcome. I'm glad I can help. Please close the thread. If you got the solution you needed.

BR,

Vijay

[vvira1316]

Hi Satish,

If you have found the answer to this question then please close the thread.

Qlik Community Tip: Marking Replies as Correct or Helpful

[vvira1316]

Hi Satish,

I appreciate you marking answer as Helpful and responding to requests but what I really wanted you to do was select an answer if there is any that is a correct solution to your question.

If there is none but you have found a solution then you can just close it by marking your question "assumed answered"

BR,

Vijay

[Anonymous]

How do I close?

[vvira1316]

Hi,

If someone replied to you then you will see following Correct Answer option. You just select that and it will mark your post answered.