topic Re: Exclude in script in QlikView

Exclude in script

Anonymous — Tue, 19 Nov 2013 08:30:15 GMT

No	Store	ProductA	ProductB	ProductC	ProductD	ProductE	Amount
1	StoreA	A	A	A	A	A	99
2	StoreA	A	F	F	F	F	2000
3	StoreA	A	D	D	D	D	300
4	StoreA	E	E	E	V	J	4000
5	StoreA	E	T	C	C	U	800
6	StoreA	B	B	B	B	B	999

Hi Community,

I want to exclude row1 and row 6, how should i put it in my script?

LOAD No,

Store,

ProductA,

ProductB,

ProductC,

ProductD,

ProductE,

Amount

From Excel

where not ProductA=ProductB=ProductC=ProductD= ProductE;

Re: Exclude in script

kaushiknsolanki — Tue, 19 Nov 2013 08:43:10 GMT

Hi,

Try this.

DATA:

LOAD No,

Store,

ProductA,

ProductB,

ProductC,

ProductD,

ProductE,

Amount,

If((ProductA=ProductB) and (ProductB=ProductC) and (ProductC=ProductD)and (ProductD=ProductE) ,1,0) as Flag

FROM

C:\Users\Kaushik\Desktop\Book1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Data:

Load No,

Store,

ProductA,

ProductB,

ProductC,

ProductD,

ProductE,

Amount

Resident DATA where Flag=0;

Drop table DATA;

Regards,

Kaushik Solanki

Re: Exclude in script

Tue, 19 Nov 2013 09:09:33 GMT

Hi,

I would do sth like:

WHERE replace(ProductA & productB, PorductC, ProductD, productE, productA, '') <> ''

The advantage is that you can add a field very easily.

Fabrice

Re: Exclude in script

jagan — Tue, 19 Nov 2013 09:21:35 GMT

HI,

Try like this

DATA:

LOAD No,

Store,

ProductA,

ProductB,

ProductC,

ProductD,

ProductE,

Amount

FROM DataSource

WHERE (ProductA=ProductB) and (ProductB=ProductC) and (ProductC=ProductD)and (ProductD=ProductE);

Hope this helps you.

Regads,

Jagan.

Re: Exclude in script

Anonymous — Wed, 20 Nov 2013 02:24:43 GMT

Thanks everyone for your help.

I put like this:

DATA:

LOAD No,

Store,

ProductA,

ProductB,

ProductC,

ProductD,

ProductE,

Amount

FROM DataSource

WHERE not ((ProductA=ProductB) and (ProductB=ProductC) and (ProductC=ProductD)and (ProductD=ProductE));

Re: Exclude in script

jagan — Wed, 20 Nov 2013 02:31:38 GMT

Hi,

Missed Not in my where condition, Good Catch. Anyway close this disucssion.

Regards,

Jagan.

Re: Exclude in script

nihhalmca — Thu, 21 Nov 2013 13:22:12 GMT

Hi SurynnChin,

Try this

LOAD

Store

ProductA

ProductB

ProductC

ProductD

ProductE

Amount

FROM Excel file

Where not No=1 and 6;