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: 
bharatkishore
Creator III
Creator III

Need to show top 3 color coding

Hi All,

I have an  straight table chart. I have an expression like (sum([Unique Opens])/sum([Total Sends]-([Total Bouncebacks])))

You can see the values as in the attached image:

Now my requirement i need to show i mean highlight the values in green color which are top 3. I need to show it with an indicator.

Kindly help.

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

I *think* this is what you want?

View solution in original post

41 Replies
beck_bakytbek
Master
Master

Hi Bharat,

try to use in Expression: backround Color,

beck

bharatkishore
Creator III
Creator III
Author

Hi Beck,

I need to add one more expression like you know it should show with traffic signal or  indicator.

arulsettu
Master III
Master III

can u post sample qvw

adamdavi3s
Master
Master

Here is a quick example using RANK in the background colour of the expression.

just adapt it to your needs by using: rank((sum([Unique Opens])/sum([Total Sends]-([Total Bouncebacks]))))

beck_bakytbek
Master
Master

Hi Bharat,

what Kind of traffic Signal or indicator do you Need? Gauges?

beck

bharatkishore
Creator III
Creator III
Author

Hi Arul,

Please find the attached qvw.

bharatkishore
Creator III
Creator III
Author

Hi Beck,

I needed an indicator.

bharatkishore
Creator III
Creator III
Author

HI Adam,

Thanks for the qvw i have tried with your sample qvw but i am getting all in green color.

Attached qvw for your reference..

adamdavi3s
Master
Master

You need to use aggr and rank to solve this if you have multiple dimensions. With one this will work fine.

Have a look in the community for  "top n" and you should find plenty of examples.

Searching for: Top N list with 2 dimensions

will get you a very good explanation.