topic Set analysis affected by selection criteria in QlikView

Set analysis affected by selection criteria

Thu, 29 Sep 2011 23:14:48 GMT

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

Set analysis affected by selection criteria

swuehl — Thu, 29 Sep 2011 23:22:28 GMT

Hi,

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

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

Regards,

Stefan

Set analysis affected by selection criteria

Fri, 30 Sep 2011 14:40:04 GMT

Hi stefan,

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