topic Highlight highest column in QlikView

Highlight highest column

ivandrago — Thu, 02 Oct 2014 20:41:53 GMT

Hi,

I have the attached document, I want to highlight in red the cell which has the highest value for each of the columns "Order Price" and "Products"

Thanks

Re: Highlight highest column

julian_ortiz — Thu, 02 Oct 2014 20:56:26 GMT

Hi Ivan.

Something like this? Using Rank()

Check the property BackGround Color

Regards

Re: Highlight highest column

maxgro — Thu, 02 Oct 2014 20:59:06 GMT

if(sum(OrderPrice)=max(total aggr(sum(OrderPrice),MonthYear)),rgb(255,0,0))

if(count (distinct productId)=max(total aggr(count (distinct productId),MonthYear)),rgb(255,0,0))

Re: Highlight highest column

Thu, 02 Oct 2014 21:14:11 GMT

Hi Ivan,

Go to properties-> visual cues -> and set the background color as red and define a formula for upper limit or lower limit as per your requirements. I have implemented the requirement you asked for in the following attachment as example. Hope this helps.

Regards,

Sonya

Re: Highlight highest column

MarcoWedel — Fri, 03 Oct 2014 06:37:46 GMT

Hi,

other versions of the background color expressions:

Pick(Rank(Sum(OrderPrice)), LightRed())

Pick(Rank(Count(Distinct productId)), LightRed())

hope this helps

regards

Marco

Re: Re: Highlight highest column

MarcoWedel — Fri, 03 Oct 2014 07:26:29 GMT

or maybe even shorter:

Pick(Rank([Order Price]), LightRed())

Pick(Rank([# Products]), LightRed())

hope this helps

regards

Marco