topic Re: selection of object based on other object in QlikView

selection of object based on other object

ashishtams — Fri, 08 Jul 2016 12:51:34 GMT

Hi All,

I have a list box which has three values as

MusicNY

MusicLN

MusicAsia

I also have one straight table chart with dimension as region and expression as total, with values as somewhat like this

NY 2300

LN 5000

HK 8965

TK 5486

I also have a current selections box which shows me the current selections

Want i want to achieve is when i click on a a value of the list box, say MusicNy then the region NY should be selected and shown in the current selection, and when i click on MusicAsia then region HK and TK must be selected.

and If i clear all then everything gets clear all.

I tried to put a set analysis in the expression of the straight table, but its only limited to that table, i want the region selection to be global,

Thanks

Re: selection of object based on other object

boorgura — Fri, 08 Jul 2016 14:12:37 GMT

Have a Trigger on that field to select the Region

You can set a Field Trigger from "Document Properties" --> Triggers Tab

Re: selection of object based on other object

settu_periasamy — Fri, 08 Jul 2016 14:29:27 GMT

I think, we can do this in some ways. One solution would using 'Conditional enable'

sample attached

Re: selection of object based on other object

ashishtams — Mon, 11 Jul 2016 10:44:47 GMT

I did apply a filter using the Trigger, but i am not able to apply filter for 2 values like HK and TK for MusicAsia.

Moreover its not getting clear with clear button in one go.

Re: selection of object based on other object

ashishtams — Mon, 11 Jul 2016 10:46:28 GMT

This is correct but its in a expression, as i said i wanted it globally like if a new block/ chart is created tomorrow then i will not have to add it in expression all the time.

It should simply be a filter like a list box selection or something else..

Regards,

Re: selection of object based on other object

settu_periasamy — Mon, 11 Jul 2016 11:31:55 GMT

check the attachment using trigger.

Re: selection of object based on other object

ashishtams — Mon, 11 Jul 2016 12:25:48 GMT

thanks! this works

can i add one more thing to it, lets say the regions list one null and it has some total count.

i want to include this null in every selection of list box along with respective region.

So now as you have the pipe introduced, how can i add the null from the region list.

Re: selection of object based on other object

settu_periasamy — Mon, 11 Jul 2016 14:04:40 GMT

I think, you can just add two single quotes.