topic Re: Exclude error Data aggr in QlikView

Exclude error Data aggr

Anonymous — Wed, 03 Aug 2016 13:44:51 GMT

Hiho friends

have a problem in my report, as there is some not needed data. The problem is that we have sales order lines errors, which are stated with unti price 999999 in the source.

whats the easiest way to exclude the wrong orderline from the line chart? i was just able to cancel the whole month, but not the single order line

Thansk for help

Re: Exclude error Data aggr

sunny_talwar — Wed, 03 Aug 2016 13:47:14 GMT

May be like this:

Sum({<[Unit Price] -= {99999999}>}[Unit Price] * QTY)

Re: Exclude error Data aggr

Anonymous — Wed, 03 Aug 2016 13:47:53 GMT

try this Expression (Count of 9 correct?):

Sum({<[Unit Price]-={99999999}>}[Unit Price] * QTY)

Re: Exclude error Data aggr

Anonymous — Wed, 03 Aug 2016 14:04:50 GMT

Thanks