Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi Nagaraju,
Thanks for your response, i have used expression you have given. but it is not working .
Can you share your app? And where exactly you are using this expression?
how to attach app here, could you please help??
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.
Hi,
Please find the app, thank you, im referring to Employee salary details table
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?
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())))
I have emailed you data files to vishsaggi@gmail.com