Discussion Board for collaboration related to QlikView App Development.
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.
= 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.
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:
click on attach.
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())))