topic Re: Need to show top 3 color coding in QlikView

Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 11:58:12 GMT

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.

Re: Need to show top 3 color coding

beck_bakytbek — Mon, 01 Aug 2016 12:09:15 GMT

Hi Bharat,

try to use in Expression: backround Color,

beck

Re: Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 12:15:16 GMT

Hi Beck,

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

Re: Need to show top 3 color coding

arulsettu — Mon, 01 Aug 2016 12:16:20 GMT

can u post sample qvw

Re: Need to show top 3 color coding

adamdavi3s — Mon, 01 Aug 2016 12:17:55 GMT

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

Re: Need to show top 3 color coding

beck_bakytbek — Mon, 01 Aug 2016 12:19:03 GMT

Hi Bharat,

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

beck

Re: Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 12:24:34 GMT

Hi Arul,

Please find the attached qvw.

Re: Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 12:24:57 GMT

Hi Beck,

I needed an indicator.

Re: Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 12:26:04 GMT

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..

Re: Need to show top 3 color coding

adamdavi3s — Mon, 01 Aug 2016 12:39:43 GMT

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.

Re: Need to show top 3 color coding

arulsettu — Mon, 01 Aug 2016 12:49:33 GMT

is this u want

Re: Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 14:01:26 GMT

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

Thanks,

Bharat

Re: Need to show top 3 color coding

arulsettu — Mon, 01 Aug 2016 14:05:17 GMT

check this

Re: Need to show top 3 color coding

adamdavi3s — Mon, 01 Aug 2016 14:16:27 GMT

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.

Re: Need to show top 3 color coding

bharatkishore — Mon, 01 Aug 2016 14:30:29 GMT

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

Re: Need to show top 3 color coding

adamdavi3s — Mon, 01 Aug 2016 14:32:37 GMT

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

Re: Need to show top 3 color coding

bharatkishore — Tue, 02 Aug 2016 07:16:33 GMT

hi Adam,

Still i am unable to get my requirement..

Re: Need to show top 3 color coding

adamdavi3s — Tue, 02 Aug 2016 07:20:44 GMT

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

Re: Need to show top 3 color coding

adamdavi3s — Wed, 03 Aug 2016 08:57:15 GMT

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?

Re: Need to show top 3 color coding

bharatkishore — Wed, 03 Aug 2016 10:56:16 GMT

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