topic Re: Set Analysis Help in QlikView

Set Analysis Help

richard_chilvers — Tue, 07 Jul 2015 08:40:18 GMT

Please could you advise me on the Set Analysis to achieve the following:

I may have selections on a range of fields, let say Field1, Field2 and Field3.

I would like to see all data, but with just the selection in Field1 (only) applied.

I understand how to achieve this by excluding selections in Field2 and Field3, but at any time, I don't know how many fields have selections.

Thanks

MK_QSL — Tue, 07 Jul 2015 08:44:53 GMT

SUM({<Field2=, Field3=>}Sales)

richard_chilvers — Tue, 07 Jul 2015 08:48:17 GMT

Thanks Manish, but I may have selections in Field4, Field5, ............ and I want to ignore them all.

So I need a set definition which is {1} - <Selection in Field1>.

lironbaram — Tue, 07 Jul 2015 08:52:18 GMT

sum({1<Field1=p(Field1)>}Sales)

this function disregards any selection any the model , and then reapply the field1 selections

Tue, 07 Jul 2015 08:53:53 GMT

u can use1-$ for exclude

MK_QSL — Tue, 07 Jul 2015 08:59:32 GMT