topic qualify/unqualify syntax error in QlikView

qualify/unqualify syntax error

Thu, 10 Nov 2011 12:45:31 GMT

Can anyone tell me why this piece of code isnt working? Ive had a look around and cant seem to find the right syntax. Thanks

[billing]:

QUALIFY *;

UNQUALIFY @1;

NOCONCATENATE

LOAD

@1 as COMP_CODE,

@2 as PLANT,

@3 as SALESEMPLY,

@4 as SALES_GRP,

@5 as SALES_OFF,

@6 as SHIP_POINT,

@7 as DOC_CATEG,

@8 as BILLTOPRTY,

@9 as CUST_GROUP,

qualify/unqualify syntax error

kamalqlik — Thu, 10 Nov 2011 13:18:51 GMT

I think may be due to due to the comma that you are using after @9 as Cust_Group.

after removing it is working for me

qualify/unqualify syntax error

Thu, 10 Nov 2011 14:04:01 GMT

Sorry, here's the full code. Is it something to do with trying to specify which field to unqualify?

[billing]:
QUALIFY *;
UNQUALIFY @1;
NOCONCATENATE
LOAD
@1 as COMP_CODE,
@2 as PLANT,
@3 as SALESEMPLY,
@4 as SALES_GRP,
@5 as SALES_OFF,
@6 as SHIP_POINT,
@7 as DOC_CATEG,
@8 as BILLTOPRTY,
@9 as CUST_GROUP,
@10 as PAYER,
@11 as SHIP_TO,
@12 as SOLD_TO,
@13 as MATERIAL,
@14 as MATL_GRP_1,
@15 as VERSION,
@16 as VTYPE,
@64 as SUBTOTAL_6,
@65 as TAX_VALUE, //tax_value
@66 as INFOPROV

FROM
[SD_02.CSV]
(txt, codepage is 1252, no labels, delimiter is ';', msq);
UNQUALIFY*;

qualify/unqualify syntax error

its_anandrjs — Thu, 10 Nov 2011 14:13:43 GMT

Hi,

In place of

UNQUALIFY @1;

use

UNQUALIFY COMP_CODE;

rest of code is ok

HTH

Rgds

Anand