Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

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
lironbaram
Partner - Master III
Partner - Master III

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
MK_QSL
MVP
MVP

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

richard_chilvers
Specialist
Specialist
Author

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
Partner - Master III
Partner - Master III

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

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

Not applicable

u can use1-$ for exclude