topic Re: Can't clear filter in Qlik Sense in App Development

Can't clear filter in Qlik Sense

sjb34300 — Fri, 30 Oct 2015 03:27:02 GMT

I'm at a loss and hoping for some help. I have an app in My Work that no matter how many times I clear the filter, it always returns the next time I open the report. I don't have any bookmarks for this report and can't figure out why this filter is always set. I've cleared my cache/cookies and even rebooted the server to try to shake this loose. I'm not sure if this is a bug or if I've done something wrong. Any ideas on how to clear this filter so when I run this report, no filters are selected?

Re: Can't clear filter in Qlik Sense

ogster1974 — Fri, 30 Oct 2015 15:32:33 GMT

Perhaps you had this filter set when you saved the App. This would cause it to return. Save the App with out any filters selected and this should fix it.

Re: Can't clear filter in Qlik Sense

Fri, 30 Oct 2015 15:38:40 GMT

I have had the same problem - ended up Exporting it in QMC, importing it into Desktop version, then reversing the process.

Re: Can't clear filter in Qlik Sense

sjb34300 — Fri, 30 Oct 2015 16:00:13 GMT

Thanks for the help. Exporting to the Desktop version, clearing the filter, saving the sheet, then importing this QVF back into Server worked.

This seems like a bug within Server. I suspect if there was a "save" button within the sheet in Server, this would work. I tried editing the sheet, clearing the filter, clicking done and that didn't work. I also tried editing the App name after removing the filter thinking that might "save" the app/sheet - didn't work.

Re: Can't clear filter in Qlik Sense

Anonymous — Sun, 13 Dec 2015 18:55:43 GMT

I am having the same issue and we don't have the desktop version (or the ability to download it on work PCs) so if anyone has a solution that doesn't involve the desktop version I would be greatly appreciative.

Re: Can't clear filter in Qlik Sense

Wed, 20 Jan 2016 20:31:32 GMT

The problem does begin as Andy W describes, but here is what I do to clear the “sticky” filter:

Remove the filter field from the dimension table in the Load script.
Remove the filter field from the measure table in the Load script (as needed).
Load the data.
Without opening the app, place the field back into the Load script.
Load the data again.