Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

pljsoftware
Contributor III

Highlight max and min values in pivot table

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.

1 Solution

Accepted Solutions
pljsoftware
Contributor III

Re: Highlight max and min values in pivot table

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

22 Replies

Re: Highlight max and min values in pivot table

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
Contributor III

Highlight max and min values in pivot table

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

Highlight max and min values in pivot table

Hi,

Can you share any sample file it goes so easy.

Rgds

Anand

Not applicable

Highlight max and min values in pivot table

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
Valued Contributor

Highlight max and min values in pivot table

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

rominavilla
New Contributor III

Re: Highlight max and min values in pivot table

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.

Not applicable

Re: Highlight max and min values in pivot table

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

Not applicable

Re: Highlight max and min values in pivot table

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

rominavilla
New Contributor III

Re: Highlight max and min values in pivot table

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.