topic Set Analysis/ If Statement in QlikView

Set Analysis/ If Statement

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Set Analysis/ If Statement

swuehl — Thu, 19 May 2016 11:40:57 GMT

Use the intersection operator

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

Re: Set Analysis/ If Statement

Anonymous — Thu, 19 May 2016 11:42:54 GMT

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

Re: Set Analysis/ If Statement

Thu, 19 May 2016 12:00:03 GMT

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