Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
anna_elle
New Contributor

Filter within single worksheets or graphs

Hello qlik Folks,

is there a possibility to make a condition filter that applys only for one Chart? I thought of using the formular of the measures. Insted of a simple Sum (Orders) could I use some think like

Sum(orders) Where Country = US

or

Only({<Country={"US"}>} Sum(Orders))

 

Thank you for your help!!

 

 

 

3 Replies
Partner
Partner

Re: Filter within single worksheets or graphs

HI,

You can use Set Analysis Sum({<Country={'US'}>}Orders)

Or if you what to drive it with a filter look at the Alternate States in the Nov release.

Mark
Employee
Employee

Re: Filter within single worksheets or graphs

Alternate State should be better than set analysis.
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...
Ricardo Gerhard
OEM Solution Architect
LATAM
612118513
New Contributor II

Re: Filter within single worksheets or graphs

Hi Anna

 

If i understand correctly what you want is a chart that shows the result of a conditional sum, in that case the best option is add in the expression of the chart the follow:

SUM({$< [Orders]= {'US'}>}[Orders])

BR