topic Re: Row wise comparison in Pivot table in QlikView

Row wise comparison in Pivot table

rkspareek1992 — Thu, 10 May 2018 06:06:52 GMT

Hi,

I have three tables A, B & C. In tables A, B & C I have Total target, MTD target and Actual data respectively. I have concatenated all three tables to show the data in below-mentioned form.

MTD Production	Location	Totals	Plant1	Plant2	Plant3
Month Target (A)		3,236	2,259	620	357
MTD Target (B)		939	656	180	104
Total Actual (C)		1,096	619	304	174

Expression of A, B & C is Sum(Total target), Sum(MTD Target) and Sum(Actual) respectively.

Now I want to compare B and C, if Sum(Actual) <Sum(MTD Target), Red, Green.

and output should be like as:

MTD Production	Location	Totals	Plant1	Plant2	Plant3
Month Target (A)		3,236	2,259	620	357
MTD Target (B)		939	656	180	104
Total Actual (C)		1,096	619	304	174

Kindly suggest the expression for color.

Re: Row wise comparison in Pivot table

karthikoffi27se — Thu, 10 May 2018 06:20:50 GMT

Hi Rakesh,

Under the expression you have color by text (Text Color). Use the expression if (Sum(Actual) <Sum(MTD Target), Red(), Green()).

This should work

Many Thanks

Karthik.

Re: Row wise comparison in Pivot table

rkspareek1992 — Thu, 10 May 2018 06:29:14 GMT

I have tried, but its only working for Totals, not for all plants (which are used as columns).

I have also tried as:

if(Sum(<Total Plant>Actual) <Sum(<Total Plant>MTD Target), Red(), Green())