topic Re: Set Analysis: Ignore All Selections except for one field in QlikView

Set Analysis: Ignore All Selections except for one field

Anonymous — Wed, 16 Mar 2016 15:40:14 GMT

Is there any simple way in Set Analysis to ignore all selections, except for one field that we want the selections for ?

Re: Set Analysis: Ignore All Selections except for one field

sunny_talwar — Wed, 16 Mar 2016 15:41:58 GMT

May be this Bill:

{1<FieldName = $::FieldName>}

Re: Set Analysis: Ignore All Selections except for one field

Gysbert_Wassenaar — Wed, 16 Mar 2016 15:48:36 GMT

{1<FieldName=P(FieldName)>}

Re: Set Analysis: Ignore All Selections except for one field

sunny_talwar — Wed, 16 Mar 2016 15:56:34 GMT

Gysbert, but this can still be impacted by other field selections. Lets say I have a product (Product A) which is only available in 2 of the three years and I have an expression like this -> Sum({1<Year = p(Year)>} Sales). If now I select Product A, I will only see the data for the two years because p(Year) will be the those two years where we have sales for Product A.

Re: Set Analysis: Ignore All Selections except for one field

Anonymous — Wed, 16 Mar 2016 15:58:53 GMT

Many thanks Sunny & Gysbert. In my data scenario they both work perfectly.

Re: Set Analysis: Ignore All Selections except for one field

Gysbert_Wassenaar — Wed, 16 Mar 2016 16:04:33 GMT

You're completely right. Usually the possible values are what is wanted though. That's what the user can see as selected values.

Re: Set Analysis: Ignore All Selections except for one field

user-azadi — Wed, 18 Aug 2021 10:41:53 GMT

thank you sunny . great solution

but what mean $:: in your expression? i search community but not found any thing about it!

Re: Set Analysis: Ignore All Selections except for one field

tresB — Wed, 18 Aug 2021 11:08:37 GMT

@user-azadi

Have a look at this document that I created, hope that helps in understanding it better : Ignore-all-selections-except-few-fields-using-Set-Analysis