Qliksense Pivot table multiple measure comparison for single dimension with multiple values

[Cbhuvi27]

Hello All,

I wanted to compare the multiple measures  of dimension and create new column with data like if all the measures are same then red else no colour.

for eg: 

Week	Date	Name1	Name2	Name3	Delta
1	1/2/2023	100	100	100
	1/3/2023	100	2	100	red()
	1/4/2023	100	100	100

Here Week and Date will be Row

Name will be column

sum(sales) would be measure

Delta is the extra column we need to create to compare measures of name1,2 and 3

[Cbhuvi27]

Thanks much for the reply Vincent. How do i compare each cell and highlight the whole row even if one value is different ? 

[vincent_ardiet_]

Sorry but this is not clear to me.
You want now to highlight the whole row even if one value is different? I thought you want to indicates the rows where all values are the same?
I'm a bit lost.

[Cbhuvi27]

Yes wanted to highlight  the whole row with red even if one value is different or else green

[vincent_ardiet_ · Accepted solution]

Like this
If(Min(TOTAL <DATE,YEAR> Aggr(Sum(VALUE),TYPE,DATE,YEAR))=Max(TOTAL <DATE,YEAR> Aggr(Sum(VALUE),TYPE,DATE,YEAR)),green(),red())

[Cbhuvi27]

Great ! it worked.. thanks much 🙂