topic Re: set analysis and filters in App Development

set analysis and filters

Fri, 05 Feb 2016 17:01:00 GMT

sum({$<Year={2000}”}>} Sales)

Returns the sales for current selection, but with new selection year=2000. if someone applies a filter year=2001, the above set analysis still returns sum of sales for year 2000. How do i modify this so that if a user applies no year filter it return sum of sales for year 2000, but if a user applies a filter year other then 2000, then the function returns 0?

Re: set analysis and filters

Gysbert_Wassenaar — Fri, 05 Feb 2016 18:07:06 GMT

sum({$<Year*={2000}>} Sales). The * means intersect the user selection with the value 2000. So if the user selections something else than 2000 the intersection will be empty and the expression returns 0.

Re: set analysis and filters

swuehl — Fri, 05 Feb 2016 18:10:18 GMT

Use the intersection operator *

sum({$<Year *= {2000}”}>} Sales)

Re: set analysis and filters

Fri, 05 Feb 2016 19:55:04 GMT

Wow, that's easy. Thanks Gysbert