Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Colour Top3 Salary by expression

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.

doubt.PNG

14 Replies
Highlighted
Champion III
Champion III

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) ?

Highlighted
Partner
Partner

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

Highlighted
Champion III
Champion III

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.

View solution in original post

Highlighted
Partner
Partner

Thank you, sure I would try and let you know

Highlighted
Partner
Partner

Hi ,

Its working perfect, Thank you so much