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: 
wdchristensen
Specialist
Specialist

Ignore all selections except one filter in set analysis (QS April 2018 so no alternate state)

I have application that I would like to show totals and only respect the year filter. The year filter is defined as Year(EventDate). Current I am using the formula below to ignore all selections except the year filter with limited success.

Sum({1< EventDate =P(EventDate)>} Days)

It seems to ignore selections with the year but starts to break down on certain selections if multiple years are selected. Any thoughts on how I can improve this formula?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Sum({1< EventDate =$::EventDate>} Days)

For better understanding you may refer the document I wrote : Ignore all selections except few fields using Set Analysis

View solution in original post

4 Replies
Marcos_rv
Creator II
Creator II

Try this :

 

Sum({<field1,field2,field3,field4.... >} Days)

 

No encuentro otra manera, o que hagas una tabla flotante solo para ese grafico y lo relaciones mediante el calendario.

 

Saludos!!!

wdchristensen
Specialist
Specialist
Author

I was thinking something more along the lines of GetFieldSelections with set analysis. 

tresesco
MVP
MVP

Try like:

Sum({1< EventDate =$::EventDate>} Days)

For better understanding you may refer the document I wrote : Ignore all selections except few fields using Set Analysis

wdchristensen
Specialist
Specialist
Author

Elegant solution and a great article!