topic Re: Filter on legends in QlikView

Filter on legends

Anonymous — Thu, 04 May 2017 21:55:24 GMT

Please find the attached application , i want to create filters on legends .. so basically if one clicks on Grenn legend - inside sla .. i should be filtering out all greens in the table .. is that possible ?

Thanks

Re: Filter on legends

Siva_Sankar — Fri, 05 May 2017 03:44:02 GMT

Hi Radhika,

Create a calculated field in the front end like below,

If(isnull([Rum Overall TP50]),'Red',

if(([Rum Overall TP50])< $(vOverallTarget),'Green',

IF(([Rum Overall TP50]) > [Rum Overall Bridge TP50],'Red',

IF(([Rum Overall TP50]) < [Rum Overall Bridge TP50]and ([Rum Overall TP50]) > [Rum Network Target TP50],'Yellow'))))

Siva

Re: Filter on legends

Anonymous — Fri, 05 May 2017 17:15:43 GMT

Hi Siva

this is the expression for back ground color right ? can you please eloborate why we are doing this and how it will help to enable legends ? .. i basically want to click on colored legends and the selected color legend should be filtered in the table .. so say for eg if i click on Inside SLA legend all the greens should be shown in the table.

Thanks!

Re: Filter on legends

Siva_Sankar — Sat, 06 May 2017 02:53:23 GMT

Radhika,

Find the attached Test.qvw..i used the below script on top of your table..

New:

Load *,

If(isnull([Rum Overall TP50]),'Red',

if(([Rum Overall TP50])< [Rum Overall Target TP50],'Green',

IF(([Rum Overall TP50]) > [Rum Overall Bridge TP50],'Red',

IF( (([Rum Overall TP50]) < [Rum Overall Bridge TP50] )and (([Rum Overall TP50]) > [Rum Overall Target TP50]),'Yellow')))) as Colorstatus

Resident [Rum OpEx Latency];

drop Table [Rum OpEx Latency];

And then i used colorstatus as action in our legend. This is for T50, you need to create for T90. Let me know if you still need help. Thanks.

Siva

Re: Filter on legends

Anonymous — Sun, 07 May 2017 06:47:36 GMT

Great !! Thank you very much!

Re: Filter on legends

Anonymous — Sun, 07 May 2017 08:37:44 GMT

Hi Siva

So i have added 6 more color expressions .. i have created a variable to pass the color values to the Overall table .. but i also have another Detail view table which has 3 metrics showing colors .. i have created 6 expressions ( 3 for tp50 and 3 for tp90 ) .. but not sure how i can pass these to the same variable ( =$(vRumColor)) ..can you help ?

i am using =$(vRumColor) as a list box to select the values ..

and one more complexity with this color expression i see it ..say for example when i select green for overall table even detail table is getting filtered on dates (from overall) .. both the table should explicitly show the colored rows... is that possible?

Thanks!

Re: Filter on legends

Siva_Sankar — Sun, 07 May 2017 10:58:53 GMT

use this in the listbox expression =if(vOverall=[Rum Overall TP50],$(vRumColor),$(vRumColor))

Re: Filter on legends

Siva_Sankar — Mon, 15 May 2017 01:55:40 GMT

Hi Radhika,

If you got the answer, mark it as correct answer and please close the thread. It may help others.

Siva