Set Analysis/ If Statement

[#1]

Hi All

Is it possible to make set analysis expression only to force certain selections when no selections are made, but once selection is made it should consider both set expression and selection/s (like an If statement)

In my Test qvw, I have both examples. In the If statement chart I can still for example, select records for 1 day but I can’t in set analysis because it forces everything to be selected.

I want to specifically use set analysis but want it to still filter selections like an if statement.

[swuehl · Accepted solution]

Use the intersection operator

Sum({$<Day *= {"<=$(vDay)"}>}Amount)

[Anonymous]

maybe this is what you want?

if a selection for day is made, the first expressiontakes place, otherwise the seond?

if (GetSelectedCount(Day)=0,
Sum({$<Day={"<=$(vDay)"}>}Amount),
Sum(Amount))

[#4]

Thanks! I learned something new today. @Rudolf Was looking for a solution that will not require an if condition. Thanks