Filter within single worksheets or graphs

[anna_elle]

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!!

[Mark_Little]

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

[Ricardo_Gerhard]

Alternate State should be better than set analysis.
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

[612118513]

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