Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
tresB
Champion III
Champion III

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. 

tresB
Champion III
Champion III

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!