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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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