topic Colour Top3 Salary by expression in QlikView

Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 17:30:09 GMT

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.

Re: Colour Top3 Salary by expression

vishsaggi — Wed, 25 Apr 2018 17:35:19 GMT

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.

Re: Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 17:43:32 GMT

Hi Nagaraju,

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

Re: Colour Top3 Salary by expression

vishsaggi — Wed, 25 Apr 2018 17:45:41 GMT

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

Re: Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 17:49:43 GMT

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

Re: Colour Top3 Salary by expression

vishsaggi — Wed, 25 Apr 2018 17:54:47 GMT

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.

Re: Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 17:55:14 GMT

Hi,

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

Re: Colour Top3 Salary by expression

vishsaggi — Wed, 25 Apr 2018 18:13:31 GMT

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?

Re: Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 18:29:22 GMT

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

Re: Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 18:32:25 GMT

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

Re: Colour Top3 Salary by expression

vishsaggi — Wed, 25 Apr 2018 18:39:05 GMT

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

Re: Colour Top3 Salary by expression

chaitanyajami — Wed, 25 Apr 2018 18:41:14 GMT

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

Re: Colour Top3 Salary by expression

vishsaggi — Thu, 26 Apr 2018 02:14:32 GMT

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.

Re: Colour Top3 Salary by expression

chaitanyajami — Thu, 26 Apr 2018 03:17:11 GMT

Thank you, sure I would try and let you know

Re: Colour Top3 Salary by expression

chaitanyajami — Thu, 26 Apr 2018 04:44:55 GMT

Hi ,

Its working perfect, Thank you so much