Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
nsm1234567
Creator II
Creator II

Set Analysis - Exclude selected items from Calc

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.

3 Replies
arasantorule
Creator III
Creator III

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,

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try this expression

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

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

Regards,

Jagan.

vipin_mishra479
Creator II
Creator II

Try this one