topic Disconnect list box from chart in QlikView

Disconnect list box from chart

Mon, 04 May 2009 14:51:05 GMT

How do I specify that a given chart shall not be impacted by a filter selction of a related list box ?

e.g. I look at revenues at company level + central entity cost. I have a list box with all BU's. Of course, looking at this view, I do not want the users to filter on a specific BU as this would mean looking at one BU revenues and central entity cost, which is meaningless.

Disconnect list box from chart

sparur — Mon, 04 May 2009 15:05:44 GMT

Hi, jeffrobertz

for example here is the solution:

sum({<BU = >}Amount)

P.S. see in attachment.

Disconnect list box from chart

yblake — Mon, 04 May 2009 15:24:59 GMT

the best way is to avoid unmeningfull charts (or page) to show when only one BU is selected is to use conditionnal display formula like =count(distinct BU) > 0, or testing if only(BU) is null.

You can also define specific error message to explain why the chart isn't shown.