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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
denispillay
Contributor III
Contributor III

Filter interaction with chart

i have 1 filter pane and 1 bar graph 

in filter pane have zone values (africa, india, japan, canada, Uk , Austrelia, N/A)

without any selection only (africa, india, japan, canada, Uk , Austrelia) profit should appear, N/A should not be there 

but when i select N/A from filter pane N/A then bar graph should show sales of N/A

 

kindly help me out

 

 

Labels (5)
4 Replies
BrunPierre
Partner - Master II
Partner - Master II

This perhaps.

=If(GetSelectedCount(zone), Sum(Sales), Sum({<zone-={'N/A'}>} Sales))

denispillay
Contributor III
Contributor III
Author

can you pls describe in detail pls

how i should apply 

 

BrunPierre
Partner - Master II
Partner - Master II

That should be the bar chart expression, where "N/A" is excluded by default but included when the user explicitly selects it or other zones.

denispillay
Contributor III
Contributor III
Author

and what about other filters it will work accordingly or not