topic Re: How to remove filter pane but retain the data? in QlikView

How to remove filter pane but retain the data?

Anonymous — Mon, 19 Feb 2018 19:04:37 GMT

Please suggest a way if I can remove the filter pane but data still shown for Repeated Users = "Repeated" without doing any changes in Load Script.

So I want to see data relevant to Repeated Users but without having to select the option from filter pane. So even if there is no filter pane, data should only be shown for "Repeated" (filter pane option). Only condition is I do not want to hard code this in script.

Thank you!!

Re: How to remove filter pane but retain the data?

jwjackso — Mon, 19 Feb 2018 20:18:12 GMT

You could use set analysis in you charts, you don't have to have a filter for this field on the sheet.

Sum({$<[Repeated Users = {'Repeated'}>}

You could also create a trigger on the sheet to set the filter to 'Repeated', again you would not have to have a filter pane on the sheet. However, if there is a filter pane for this field on another chart I would recommend using the set analysis.

Re: How to remove filter pane but retain the data?

Anonymous — Mon, 19 Feb 2018 20:55:42 GMT

Jerry, Thanks for the reply.

Your suggestion should work, but when I am writing this ----- Count({$<[Repeated User]= {'Repeated'}>})

It indicates there is error in expression which says "Count takes one parameter only".

Please suggest how should I fix this?

Re: How to remove filter pane but retain the data?

Anonymous — Mon, 19 Feb 2018 21:16:16 GMT

I get that, I did Count({$<[Repeated User]={Repeated}>}[Repeated User]) and it is working

Thank you so much for your help!

Re: How to remove filter pane but retain the data?

vishsaggi — Mon, 19 Feb 2018 21:20:01 GMT

You have to mention the field name you are counting on like

= Count({$<[Repeated User]= {'Repeated'} >} DimensionFieldNamehere)