Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Incorrect data when making selections

We analyse failed shipments to customers by reason codes. When we make a selection on code WHMP this will give us details of what shipmenst were involved.

We then have a  chart which includes the expression  'Count (Distinct If (FOCReason='WHMP', [Order Number], null()))'.  However the details also appear in another chart which includes the expression  'Count If (FOCreason='WHUP',[Order Number], null()))'.How do we stop this happening?

1 Reply
rahulgupta
Contributor III

Incorrect data when making selections

Hey Hi,

You can use Set Analysis and ByPass the Filter,

For that you may use the following Code:

Count ({<FOReason=,FOCreason={'WHUP'}>}[Order Number])

Hope this helps...

Regards    

Community Browser