Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Disconnect list box from chart

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.

2 Replies
sparur
Specialist II
Specialist II

Hi, jeffrobertz

for example here is the solution:

sum({<BU = >}Amount)

P.S. see in attachment.

yblake
Partner - Creator II
Partner - Creator II

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.