topic Incorrect data when making selections in QlikView

Incorrect data when making selections

Thu, 28 Jul 2011 10:31:57 GMT

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?

Incorrect data when making selections

rahulgupta — Mon, 01 Aug 2011 09:16:01 GMT

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