topic Re: List box connections to objects in QlikView

List box connections to objects

Tue, 07 Jan 2014 10:29:04 GMT

Hi, I am making a dashboard with two graphs; one showing the number of loads transported per carrier, and one showing the number of loads per month, as you can see in the attachment.

I want all my listboxes to be connected to both graphs, except a listbox used to select the month; I don't want this listbox affecting my graph with the number of loads per month.

How do I disconnect this listbox from the graph?

Thanks in advance.

Niek

Re: List box connections to objects

Colin-Albert — Tue, 07 Jan 2014 10:42:40 GMT

In the Number of Loads per Month chart, use a set analysis expression to exclude the month field from the expression.

sum( {<[Month Data]= >} number_of_loads)

Obviously you will need to replace [Month Data] and number_of_loads with your actual field names.

Regards

Colin

Re: List box connections to objects

manideep78 — Tue, 07 Jan 2014 10:48:33 GMT

Try below expression in "Number of Loads per month" chart

=Sum({$<Your_Month_Field= >}Your_Loads_Field)

hope this helps

Re: List box connections to objects

Tue, 07 Jan 2014 10:49:10 GMT

Hi Colin,

Yes, that worked. Thank you

Re: List box connections to objects

Colin-Albert — Tue, 07 Jan 2014 10:51:12 GMT

Can you flag the correct response as this will help other users looking for a similar answer.

Thanks.

Colin