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.

41 Replies
Anil_Babu_Samineni

Bharat Kishore wrote:


Not top 3. I need to show only top 3 in green color else no color.

What is the mean of that?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
adamdavi3s
Master
Master

You don't seem to have tried to implement my solution at all?

My solution will work, simply exclude the other colours from the ranking

bharatkishore
Creator III
Creator III
Author

Sorry typo my mistake..I need to show top 3 numbers in green color for respective market and brand.

for example: I have

1

4

5

7

6

9

Now  9,6,7, should be in green color...remaining values no color in indicator symbol..

adamdavi3s
Master
Master

So this is a new requirement to the original one?

I have no problem trying to help but this is getting a little confusing now

bharatkishore
Creator III
Creator III
Author

Hi Adam,

I have tried your solution as well.

But please see the attached image: here also i can see you can see highlighting only two are in green color. I Need top 3.

bharatkishore
Creator III
Creator III
Author

No no.. this is of yesterday requirement..

adamdavi3s
Master
Master

There is something really weird going on with your chart and the way it is displaying. It's not showing all values and I can't spot why but there must be something obvious

I created a new one and it works fine, see bottom right table:

top three highlight.PNG

bharatkishore
Creator III
Creator III
Author

Yes i needed exactly the same way.. can u pls help how can i get that one..

N what expression i need to add..

sudeepkm
Specialist III
Specialist III

I agree with Adam Davies. Please check your data it seems something is not right some sort or redundant data might be causing issue. anyways I did a rank total and then a sorting on the rank and found the solution the way you want. please take a look.

c227357.PNG

adamdavi3s
Master
Master

I did nothing other than what I showed in my example above.

I don't think its a data issue but something in your table is really screwy!