topic Linking a List Box to only 1 object in QlikView

Linking a List Box to only 1 object

Thu, 27 Feb 2014 09:15:03 GMT

Good Day Qlik Community,

I would like to know if it is possible in Qlikview to link a ListBox to only 1 Object and it should remain on one selection?

Kind Regards,

Sanjeev

Re: Linking a List Box to only 1 object

its_anandrjs — Thu, 27 Feb 2014 09:25:03 GMT

Hi,

You have to use set analysis for this on charts and apply filter for the list box selection by avoiding the selection and by bypassing the selection like Year=, Month= in set analysis syntax. And for single selection use always on selection option in object properties.

HTH

Thanks & Regards

Re: Linking a List Box to only 1 object

Thu, 27 Feb 2014 11:42:36 GMT

Thanx Anand. I will try that.

Re: Linking a List Box to only 1 object

Thu, 27 Feb 2014 12:01:36 GMT

See also Alternate States, which are another scope of the data. Therefore you may have on the same sheets charts with the selection1, another chart with selection 2

You create your Alternate State (Document Properties/ General Tab / Button Alternate State)

You create your ListBox linking it to the just created Alternate State

Create your chart and link it to the alternate also. If you want to link one single dimension (as far as I understood), perhaps do not: use rather the set analysis: sum({<$YEAR = [Your Alternate State]::YEAR<} YourMeasure), so that you get only YEAR from Alternate State

Fabrice

Re: Linking a List Box to only 1 object

Anonymous — Tue, 07 Feb 2017 08:20:11 GMT

There is a work around for this. Just create an Alternate state., after doing so go to Properties of both the ChartObject and the ListBox and select this new state. Now whatever you select from the ListBox will only affect the ChartObject.

To set the alternate state, go to Settings > Document Properties > General tab > Alternate States > Click 'Add' and name your state. Then you will have the option to set which state you want to use in your list box, chart, etc.