topic Re: How to where clause in Load script in QlikView

How to where clause in Load script

wallerjc — Wed, 22 Oct 2014 14:30:41 GMT

hi i'm trying to do the below, but coming up short, i know it's simple just hoping for a second pair of eyes:

Customers:

LOAD CustomerID,

ThesaurusID as theID,

PostCode,

CountryCode,

GenderName,

DateOfBirth,

MailPreference,

EmailPreference,

RentPreference,

TelephonePreference

FROM

(txt, unicode, embedded labels, delimiter is ',', msq)

where count(PostCode) <15;

I know my aggregation is wrong, but I'm not sure how to go about this in either a qlikview expression nor in the load script.

Thanks,

Re: How to where clause in Load script

its_anandrjs — Wed, 22 Oct 2014 14:35:25 GMT

Do not use the Count in the where expression write like

Customers:

LOAD CustomerID,

ThesaurusID as theID,

PostCode,

CountryCode,

GenderName,

DateOfBirth,

MailPreference,

EmailPreference,

RentPreference,

TelephonePreference

FROM

(txt, unicode, embedded labels, delimiter is ',', msq)

where PostCode < 15;

You can use variables for this also

Regards,

Anand

Re: How to where clause in Load script

wallerjc — Wed, 22 Oct 2014 14:35:28 GMT

just realised this is a stupid question not sure how to delete.

sorry

Re: How to where clause in Load script

JonnyPoole — Wed, 22 Oct 2014 14:37:46 GMT

i think you can only mark as correct in order to close the thread.

So mark yourself or ashfaq as correct.

(There are no st*pid questions)

Re: How to where clause in Load script

its_anandrjs — Wed, 22 Oct 2014 14:41:03 GMT

Sorry jonathan its Anand

@James mark any Question Correct or Help Full to close the thread its a very simple question some time mistake dones.

Regards,

Anand

Re: How to where clause in Load script

JonnyPoole — Wed, 22 Oct 2014 14:43:13 GMT

Oops my bad !. I saw the big 'A' icon and my brain made a wrong turn.

Re: How to where clause in Load script

Wed, 22 Oct 2014 15:28:17 GMT

James mark any Question Correct or Help Full to close the thread