Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chaitanyajami
Partner - Creator
Partner - Creator

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

1 Solution

Accepted Solutions
vishsaggi
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

14 Replies
vishsaggi
Champion III
Champion III

May be in your background text

= Pick(Match(Aggr(Rank(Sum([Base Salary]),0,4), JobTitle), 1, 2, 3), LightRed(), LightGreen(), LightBlue())

Change your colors accordingly using RGB() values.

chaitanyajami
Partner - Creator
Partner - Creator
Author

Hi Nagaraju,

Thanks for your response, i have used expression you have given. but it is not working .

vishsaggi
Champion III
Champion III

Can you share your app? And where exactly you are using this expression?

chaitanyajami
Partner - Creator
Partner - Creator
Author

how to attach app here, could you please help??

vishsaggi
Champion III
Champion III

NOTE: BEFORE YOU UPLOAD make sure you do not have any confidential data.

When you click on reply you should see use advanced editor on top right like below:

Then

click on attach.

chaitanyajami
Partner - Creator
Partner - Creator
Author

Hi,

Please find the app, thank you, im referring to Employee salary details table

vishsaggi
Champion III
Champion III

So sorry could not open this file. I am at work place. Can you tell me if this data is just an inline load or a from an excel file. If yes, can you send your excel sheet with less data to look into or share screen shot of your text color expression you are using in your app?

chaitanyajami
Partner - Creator
Partner - Creator
Author

Sure, I have loaded data from Excel, I have used below expression for text colour in my app.

If ( jobtiltle = 'CEO', Green(),if ( jobtiltle= 'vpsales',Blue(),if(Jobtiltle=''Regional sales manager Europe',red())))

chaitanyajami
Partner - Creator
Partner - Creator
Author

I have emailed you data files  to vishsaggi@gmail.com