Need to show top 3 color coding

[bharatkishore]

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.

[arulsettu]

is this u want

[bharatkishore]

Yes, this is exactly what i needed. Can you please send the qvw.

Thanks,

Bharat

[arulsettu]

check this

[adamdavi3s]

That doesn't look quite right to me, you need to aggregate over both dimensions as I suggested above.

Simply ranking over the first dimension isn't correct in this case, at least I assume not.

[bharatkishore]

hi Arul,

Thanks for the help. my requirement. But what i need is for traffic signal also i need to show in green color.. All the three.

As of now i can see only one. Kindly help

[adamdavi3s]

here you go this should sort it, a bit of a sneaky way of doing it but it works

concat dimensions in one dimension

add the dimension as expressions

then on presentation tab hide the dimension

credit to simon: Ranking with multiple Dimensions | Qlik Community

[bharatkishore]

hi Adam,

Still i am unable to get my requirement..

[adamdavi3s]

Can you give us some idea what is wrong in the above application?

[adamdavi3s]

have you solved this issue? If so is it possible to share the answer so when people search in the future they can see it?

[bharatkishore]

Hi Adam,

My issue is not yet resolved and I am getting all green values..Please check the attached file. Not top 3. I need to show only top 3 in green color else no color.

Thanks,

Bharat