Set analysis affected by selection criteria

[#1]

Hi,

I am using a set analysis to calculate QTY.

COUNT({ $<flag={1,2}>}QTY)

The document has two selection fields one is date and other one is state.I don't want my set analysis to be affected by the 'state' selection.

Item	qty
Bags	100
Bottles	200

Please let me know how the set analysis needs to be modified that the qty values not gets changed by the State selection but can change by date selection.

Thanks....

[swuehl · Accepted solution]

Hi,

you just need to clear the state selection within your set expression:

=COUNT({ $<flag={1,2}, state= >}QTY)

Regards,

Stefan

[#3]

Hi stefan,

Thank you so much for your help.It worked...