QlikSense - pivot table - change color of cell Row Wise

[qlik4asif]

Hello Expers,

I want to change the color of cells ,row wise

Sample Data:

T1:
Load  Inline
[
CNTY,State,city,Stock
IN,AP,Hyd,120
IN,AP,Vij,100
IN,KA,BNG,150
IN,KA,Hub,80
IN,TN,Che,180
US,NY,Bos,200
US,NY,Pen1,210
];

Load * Inline
[
city,Date,OpenOrders
Hyd,20/01/2019,30
Hyd,20/02/2019,50
Hyd,20/03/2019,50
Vij,20/01/2019,80
Vij,20/02/2019,50
Vij,20/03/2019,50
BNG,20/02/2019,80
BNG,20/03/2019,50
BNG,20/04/2019,50

];

In the ouput i need coloring row wise as below

Dimension Used:   CNTY,State,city,Stock

Column: Month

Measure: Sum(OpenOrders)

Explanation:

For Hyd City, we have available stock - 120,

With this stock we can deliver orders till Feb(30+50) - so till feb it should be green.

i guess we Need to write logic on cumulative.

[qlik4asif]

Explanation:

For Hyd City, we have available stock - 120,

With this stock we can deliver orders till Feb(30+50) - so till feb it should be green.

i guess we Need to write logic on cumulative.

[qlik4asif]

I  missed the sample output.

Here is the sample output

[qlik4asif]

Explanation:

For Hyd City, we have available stock - 120,

With this stock we can deliver orders till Feb(30+50) - so till feb it should be green.

i guess we Need to write logic on cumulative.

[imrasyed]

Experts,

I am also trying to achieve something similar.

Can anyone help on this?