topic Re: Ignore fields in QlikView

Ignore fields

Anonymous — Tue, 07 Nov 2017 10:08:53 GMT

Hi ,

I want to ignore sold to party starting from "004" and "Y". Please help me with the script. Excel file enclosed.

SOLD TO PARTY	SALES DISTRICT	NET VALUE	GROSS VALUE
0000125927	0178	11,248.12	40,171.88
0000125927	0178	24,500.00	87,500.00
0000300118	A19	0.00	2,47,418.00
0010000003	0.00	25,452.00
0010000003	0.00	25,593.00
0040000153		0.00	2,520.00
0040000153		0.00	3,150.00
0040000153		0.00	2,520.00
Y3106	0747	0.00	0.00

Thanks, Rahul.

Re: Ignore fields

sunny_talwar — Thu, 09 Nov 2017 18:29:09 GMT

May be use WildMatch

Where Not WildMatch([SOLD TO PARTY], '004*', 'Y*');

Re: Ignore fields

eduardo_dimperio — Thu, 09 Nov 2017 19:11:57 GMT

Hi Rahul

Load

FROM YOURQVD

WHERE

LEFT([SOLD TO PARTY],3) <>'004' AND LEFT ([SOLD TO PARTY],1) <>'Y';

Re: Ignore fields

Anonymous — Fri, 10 Nov 2017 04:23:42 GMT

Thanks! it solved my purpose.

Re: Ignore fields

oknotsen — Fri, 10 Nov 2017 08:27:13 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

Re: Ignore fields

eduardo_dimperio — Fri, 10 Nov 2017 17:23:14 GMT

You're Welcome, please close the question choosing a right question

Re: Ignore fields

oknotsen — Sat, 11 Nov 2017 09:05:21 GMT

Eduardo DImperio wrote:

choosing a right question

Answer