Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

selection of object based on other object

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

1 Solution

Accepted Solutions
Highlighted

Re: selection of object based on other object

check the attachment using trigger.

View solution in original post

7 Replies
Highlighted
Valued Contributor

Re: selection of object based on other object

Have a Trigger on that field to select the Region

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

Highlighted

Re: selection of object based on other object

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

sample attached

Highlighted
New Contributor II

Re: selection of object based on other object

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.

Highlighted
New Contributor II

Re: selection of object based on other object

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,

Highlighted

Re: selection of object based on other object

check the attachment using trigger.

View solution in original post

Highlighted
New Contributor II

Re: selection of object based on other object

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.

Highlighted

Re: selection of object based on other object

I think, you can just add two single quotes.