Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
is this u want
Yes, this is exactly what i needed. Can you please send the qvw.
Thanks,
Bharat
check this
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.
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
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
hi Adam,
Still i am unable to get my requirement..
Can you give us some idea what is wrong in the above application?
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?
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