topic Re: Avoid Filter Selection in QlikView

Avoid Filter Selection

manideep78 — Tue, 23 Jun 2015 11:03:02 GMT

Dear Community,

I have many filters in my application. I need to avoid 10 filter selections for one chart and all the remaining filters should be applied normal. Is there a way to write in set analysis instead of mentioning FilterName1=, FilterName2=,......... in set expression?

Thanks in advance

Regards

Manideep

Re: Avoid Filter Selection

MK_QSL — Tue, 23 Jun 2015 11:06:06 GMT

You can use Alternate State

Re: Avoid Filter Selection

stigchel — Tue, 23 Jun 2015 11:16:16 GMT

If these 10 filters are from a certain table in your data model, you can use something like this to exclude all fields from this table

//clear all fields in the Master Calendar without having to explicitly list them all.

Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}>} $Field, ']=,[') & ']=' ";

Sum ({$<$(vClearCalendar)>} Amount)

Re: Avoid Filter Selection

sujeetsingh — Tue, 23 Jun 2015 11:22:23 GMT

Sum({$<Field1-=>} Sales) will make The expression free of selection in Field1

Re: Avoid Filter Selection

manideep78 — Tue, 23 Jun 2015 12:42:09 GMT

Hi,

All fields are from same table. but except these 10 filters, I have to use all other fields from the same table.

I am looking forward to this approach.

Regards

Manideep

Re: Avoid Filter Selection

manideep78 — Tue, 23 Jun 2015 13:33:14 GMT

A small '=' in set analysis solved my problem.

This link helped me: Ignore all selections except some specific fields using Set Analysis

Thanks a lot every one for your response.

Regards

Manideep