topic Excluding Values on Load with WHERE AND.. in QlikView

Excluding Values on Load with WHERE AND..

educastri83 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, im trying to exclude some information my load statement, but one of the parts to be excluded is missing:

LOAD

..........

FROM [$(vPath)\*.xlsx]

(ooxml, embedded labels, table is data)

WHERE NOT Match (CHARGE_CODE_KEY, '2286')

and ( CHARGE_TYPE_KEY <> '1001' and CHARGE_NET_AMOUNT > 1);

The 1st part works fine, (i mean.. exclude any entry in the data where CHARGE_CODE_KEY = 2286)

but I also want to exclude cases when CHARGE_TYPE_KEY '1001' but solve when CHARGE_NET_AMOUNT it is greater than 1

It's weird but there should not be discounts with a positive sign, that's why CHARGE_NET_AMOUNT are greater than one

Pd:

Charge_type_Key '1001' are operations of discount..

Thank You

swuehl — Sat, 03 Nov 2018 16:45:03 GMT

I am not sure that I understand your requirements on the second part. What do you mean with 'but solve when ...'?

Can you maybe post some sample input records and your required output?

educastri83 — Sat, 03 Nov 2018 17:33:18 GMT

Stefan!

Thank you, I saw that it was, I made some adjustments and now it is solved

WHERE NOT Match (CHARGE_CODE_KEY, '2286')

and ( CHARGE_TYPE_KEY <> '1001' or CHARGE_NET_AMOUNT < 1);