Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
educastri83
Contributor

Excluding Values on Load with WHERE AND..

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..


stalwar1

Thank You

1 Solution

Accepted Solutions
MVP
MVP

Re: Excluding Values on Load with WHERE AND..

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

2 Replies
MVP
MVP

Re: Excluding Values on Load with WHERE AND..

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

educastri83
Contributor

Re: Excluding Values on Load with WHERE AND..

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);