Discussion board where members can get started with QlikView.
Hi, im trying to exclude some information my load statement, but one of the parts to be excluded is missing:
(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
Charge_type_Key '1001' are operations of discount..
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?
View solution in original post
Thank you, I saw that it was, I made some adjustments and now it is solved
and ( CHARGE_TYPE_KEY <> '1001' or CHARGE_NET_AMOUNT < 1);