topic Filter within single worksheets or graphs in App Development

Filter within single worksheets or graphs

anna_elle — Tue, 11 Dec 2018 15:55:52 GMT

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

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

Thank you for your help!!

Re: Filter within single worksheets or graphs

Mark_Little — Tue, 11 Dec 2018 16:00:37 GMT

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

Re: Filter within single worksheets or graphs

Ricardo_Gerhard — Tue, 11 Dec 2018 16:19:35 GMT

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

Re: Filter within single worksheets or graphs

612118513 — Tue, 11 Dec 2018 16:23:43 GMT

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])