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

1 Solution

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

14 Replies
Highlighted
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.

Highlighted
Partner
Partner

Hi Nagaraju,

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

Highlighted
Champion III
Champion III

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

Highlighted
Partner
Partner

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

Highlighted
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.

Highlighted
Partner
Partner

Hi,

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

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

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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