Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmac1971
Creator III
Creator III

Hihglight min and max in all rows of Pivot

Any way to do this, example of max's highlighted below

11 Replies
sunny_talwar

Lets say your expression is Sum(Sales), then you can try this for color expression:

If(Sum(Sales) = Sum(TOTAL <Dimension1> Sales), LightGreen())

Digvijay_Singh

I think the second Sum should be 'Max' -

If(Sum(Sales) = Max(TOTAL <Dimension1> Sales), LightGreen())

sunny_talwar

Yes, you are right , but we might need this

If(Sum(Sales) = Max(TOTAL <Dimension1> Aggr(Sum(Sales), Dimension1, Mth)), LightGreen())

Digvijay_Singh

You are right we have to have Aggr function to select max out of all months sum(value), but I think that is sufficient, do we need total<dim> now?

sunny_talwar

I think we still do because for a chart with Dimension1 and Mth as dimension

the each cell value using this expression

Max(Aggr(Sum(Sales), Dimension1, Mth))

will equal

Sum(Sales)

sunny_talwar

I just noticed there is a third dimension and the expression might need to be changed a little more

If(Sum(Sales) = Max(TOTAL <Dimension1, Dimension2> Aggr(Sum(Sales), Dimension1, Dimension2, Mth)), LightGreen())

Digvijay_Singh

Yeah! We cannot disregard first dim. Thanks

antoniotiman
Master III
Master III

Try

If(RangeMax(First(Sum(Value),1,NoOfColumns()))=Sum(Value),Green(100))

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Try this expression

IF(SUM(Value)=RANGEMAX(TOP(TOTAL SUM(Value),1,NOOFROWS(TOTAL))),GREEN()

,IF(SUM(Value) = RANGEMIN(TOP(TOTAL SUM(Value),1,NOOFROWS(TOTAL))),RED()))

Hope it helps