Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Set analysis affected by selection criteria

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.

Itemqty
Bags100
Bottles200

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

1 Solution

Accepted Solutions
MVP
MVP

Set analysis affected by selection criteria

Hi,

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

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

Regards,

Stefan

2 Replies
MVP
MVP

Set analysis affected by selection criteria

Hi,

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

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

Regards,

Stefan

Not applicable

Set analysis affected by selection criteria

Hi stefan,

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