topic Re: Option to remove filter? in QlikView

Option to remove filter?

Anonymous — Thu, 31 Aug 2017 23:10:34 GMT

I am working on a report chart that shows aggregated data for the last 10 work days. This means that there are 10 rows, one for each day. Currently, when I add the field for state, it is only 10 rows long when a single state is selected. I cannot "unselect" a state in order to look at all of the aggregated data, and if I select all then my table becomes 500 rows, 10 for each state. I would like for the report to be filterable by US state while remaining 10 rows long.

I tried adding a filter chart to do exactly this, but it added the column for states. Is there another way I can achieve what I am looking for?

Re: Option to remove filter?

effinty2112 — Fri, 01 Sep 2017 08:41:19 GMT

Hi Matthew,

Don't add State as a dimension of the chart use a separate listbox to select the State(s) you want to look at.

Cheers

Andrew

Re: Option to remove filter?

Anonymous — Fri, 01 Sep 2017 15:00:24 GMT

Thank you, this worked. Swore I had tried this already but I tried it again and all was fine.