Need to display color for only min and max

[bharatkishore]

Hi All,

I have a dimension as day where data will Sunday,Monday,....Saturday.

I have campaign field and i have written expression as Count(Campaign)

Now i have taken a straight table and displayed as

Sunday---10

Monday--40

Tuesday--50.

Now my query is i need to display color only for max and min values. Kindly .

help me how to get

[tamilarasu · Accepted solution]

Below link might be helpful.

highlight min/max values in straight table | Qlik Community

[bharatkishore]

Thanks a lot..Exactly what i am looking..

[sushil353]

Hi,

Try to use rank function as : if(aggr(rank(count(Campaign),day)=1,green(),if(aggr(rank(count(campaign)),Day)=2,yellow(),white())

HTH