topic Invalid Expression Error: Left Join in QlikView

Invalid Expression Error: Left Join

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Can someone help me understand why I'm getting the attached error when I try to run my script? I've pasted and attached my code.

Thanks,

Ben

------------------------------------------

uld_count_url:

LOAD domain_id,

id as normalized_url_id,

url as normalized_url

FROM

[silo qvds\normalized_url.qvd]

(qvd);

LEFT JOIN (uld_count_url)

//url:

LOAD id as url_id,

normalized_url_id

// url

FROM

[silo qvds\url.qvd]

(qvd);

LEFT JOIN (uld_count_url)

//uld_count_url:

LOAD id as uld_count_url_id,

url_id,

date(date_created, 'MM/DD/YYYY') as date_created,

all,

com,

edu,

gov,

net,

org,

dofollow,

nofollow,

sitewide,

not_sitewide,

refdomains,

max(uld_count) as uld_count

FROM

[silo qvds\uld_count_url.qvd]

(qvd)

where monthstart(date_created) = monthstart(today())

// group by url

;

//STORE uld_count_url INTO uld_count_url.qvd (qvd);

Re: Invalid Expression Error: Left Join

Digvijay_Singh — Tue, 30 May 2017 23:37:41 GMT

You are aggregating your rows through Max function, so you need to use Group By clause and mention all the fields which are available after load statement except those having aggregation function like Max you have used.

So you are grouping rows having same values in the fields mentioned in your group by clause and you want to find the max of uld_ count against those rows.

Re: Invalid Expression Error: Left Join

Anonymous — Wed, 31 May 2017 18:13:29 GMT

Thank you! You explained it very thoroughly and it worked. Thanks for making it easy to understand for a newbie like me