Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

richard_chilvers
Valued Contributor

Set Analysis Help

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Set Analysis Help

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

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

View solution in original post

5 Replies
MVP
MVP

Re: Set Analysis Help

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

richard_chilvers
Valued Contributor

Re: Set Analysis Help

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>.

Partner
Partner

Re: Set Analysis Help

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

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

View solution in original post

Not applicable

Re: Set Analysis Help

u can use1-$ for exclude

MVP
MVP

Re: Set Analysis Help