Colour Top3 Salary by expression

[chaitanyajami]

Hi All,

I have below table in qliksense with Sum([Base Salary]) expression, i have highlighted top 3 salaries by designation , however my requirement is to highlight top3 salaries with different colours based on expression result, please suggest how to achieve it.

[vishsaggi]

Did you try my expression in Text color ?  I mean the below expression?

= Pick(Match(Aggr(Rank(Sum([Base Salary]),0,4), JobTitle), 1, 2, 3), Red(), Green(), Blue())

what is your BaseSalary expression is it Sum(BaseSalary) ?

[chaitanyajami]

Yes , I tried the expression you have provided, it was not working, yes it's is Sum( [ Base Salary])

[vishsaggi · Accepted solution]

Try this?

= Pick(Match(Aggr(num(Rank(TOTAL Sum([Base Salary]),4)), Empname, JobTitle), 1, 2, 3), Green(), Blue(), Red())

Check attached. Remove Rank field if you don't want. Just for testing purposes i added.

[chaitanyajami]

Thank you, sure I would try and let you know

[chaitanyajami]

Hi ,

Its working perfect, Thank you so much