Solved: Re: Highlight max and min values in pivot table - Qlik Community

pljsoftware · ‎2011-11-08

Hi all!

I have a Pivot Table with many dimensions and one expression. Is it possible to highlight the cells that contain max and min expression values, depending on the current aggregations?

Kindest Regards.

pljsoftware · ‎2012-08-18

Hi all,

we have a pivot table with these dimensions

Week (Settimana)

Data (Date)

Ora (Hour)

Expresssion: QtaPasseggeri (quantity of passengers)

with espression sum(QtaPasseggeri) and expression name "Passeggeri".

The solution for this problem is to set this expression in Background Color

if([Passeggeri]=max(total aggr(sum(QtaPasseggeri), Settimana, Data, Ore),1), rgb(255,0,0),

if([Passeggeri]=max(total aggr(sum(QtaPasseggeri), Settimana, Data, Ore),2), rgb(200,0,0),

if([Passeggeri]=max(total aggr(sum(QtaPasseggeri), Settimana, Data, Ore),3), red(),

IF([Passeggeri]>800,

RGB(0,0,128),

IF([Passeggeri]>400 AND [Passeggeri]<800,

RGB(0,204,255),

IF([Passeggeri]>200 AND [Passeggeri]<400, RGB(204, 255, 255))

)

Regards

Luca Jonathan Panetta

PLJ Software

View solution in original post

its_anandrjs · ‎2011-11-08

Hi,

Write some thing like this in background properties of the expressions by click on plus sign.

If( Sum(Sales) = Max(Sales) ,Yellow(),

If( Sum(Sales) = Min(Sales) ,Green() ))

Rgds

Anand

pljsoftware · ‎2011-11-08

No, it doesn't works. Your example draws all the cells with a yellow background.

its_anandrjs · ‎2011-11-08

Hi,

Can you share any sample file it goes so easy.

Rgds

Anand

Report Inappropriate Content · ‎2011-11-09

1.go to chart properties of pivot table and go to tab visual cues.

2.select expression and give upper limit and lower limit.

3.Then the values between upper and lower limit will be highlighted.

try it out.

regards

kamalqlik · ‎2011-11-09

You can do one more thing..

Go in the visual cues tab....Here yo u will find the Upper and Lower Value....you can fix the color according to your reqirement

Anonymous · ‎2012-08-13

I have the same question. But I ordered the values ascendant by this expression:

min(aggr(count(Field), Dimension 1, Dimension 2))

But doesn't order. I want min values on the top of the table so I can highlight them and the max values down.

Report Inappropriate Content · ‎2012-08-14

Please attach the application. We all can help you out with that!

Report Inappropriate Content · ‎2012-08-14

Hi,

Write some thing like this in background properties of the expressions by click on plus sign.

If( Sum(Sales) = Max(Sales) OR Sum(Sales) = Min(Sales) ,Yellow())

Hope this helps!

Thanks,

Attitude

Anonymous · ‎2012-08-17

If( Sum(Sales) = Max(Sales) OR Sum(Sales) = Min(Sales) ,Yellow()) doesn't work.

This is the example. I want max and min values by Field2.