topic Set Analysis - Exclude selected items from Calc in QlikView

Set Analysis - Exclude selected items from Calc

nsm1234567 — Mon, 23 Nov 2015 06:44:02 GMT

Hi There,

I've been working on a solution to exclude values that are selected in a listbox from a calculation. The attached works correctly, however, it doesn't seem very elegant to me (it relies on a variable to adjust the set analysis and you also get the squiggly line, which I prefer to avoid). Can anyone think of a better way to do this? The idea is that:

When "some other date" dates are selected, those dates should be excluded from the calculation
When no "some other date" selected, there should be no exclusions from the calculation.

Does anyone have any ideas? Thanks in advance.

Re: Set Analysis - Exclude selected items from Calc

arasantorule — Mon, 23 Nov 2015 08:16:46 GMT

Hi,

I hope this will give you the solution.

=if(GetSelectedCount( [Some Other Date])>0,sum({$<[Waybill Date]=E({$}[Some Other Date])>}Amount),sum(Amount))

Thanks,

Re: Set Analysis - Exclude selected items from Calc

jagan — Mon, 23 Nov 2015 08:35:58 GMT

Hi,

Try this expression

=If(GetSelectedCount([Some Other Date]) > 0,

sum({<[Waybill Date]=E([Some Other Date])>}Amount), sum(Amount))

Regards,

Jagan.

Re: Set Analysis - Exclude selected items from Calc

vipin_mishra479 — Mon, 23 Nov 2015 09:14:09 GMT

Try this one