topic Re: Ignore all selections except one filter in set analysis (QS April 2018 so no alternate state) in App Development

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

wdchristensen — Wed, 13 Mar 2019 20:38:05 GMT

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?

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

Marcos_rv — Wed, 13 Mar 2019 20:44:39 GMT

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

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

wdchristensen — Wed, 13 Mar 2019 21:36:26 GMT

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

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

tresB — Thu, 14 Mar 2019 06:43:56 GMT

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

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

wdchristensen — Thu, 14 Mar 2019 17:20:14 GMT

Elegant solution and a great article!