Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

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

Highlighted
Specialist
Specialist

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

Highlighted
Partner
Partner

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

Highlighted
Not applicable

u can use1-$ for exclude

Highlighted