topic Re: Load script hangs while left join in QlikView

Load script hangs while left join

dhanavindhan — Thu, 31 May 2018 16:08:35 GMT

Dear Experts,

I have multiple qvd's contains some columns which are already used for different report. Now, I am creating a new dashboard screen I want only some columns from that qvd's. While I do left join in my load script my machine get hang. FYR I attached my load script image. Please help me to fix this issue in a optimized way becoz I have some more qvd to join with this and make a single table.

Regards,

Dhana R

Re: Load script hangs while left join

Anonymous — Thu, 31 May 2018 16:21:44 GMT

try it with

unqualify *;

first

Re: Load script hangs while left join

dhanavindhan — Fri, 01 Jun 2018 04:08:07 GMT

Hi,

Tanx for ur reply

I don't understand ur answer. Pls enlighten me.

Regards,

Dhana R

Re: Load script hangs while left join

Anonymous — Fri, 01 Jun 2018 16:47:52 GMT

Hi I thought perhaps you're using qualify and thatswhy the names of your keys aren't identical.

Could you please post a screenshot of the two tables (CTRL + T) without using join?