topic Re: Load Script acting crazy after upgrade to QV12 in QlikView

Load Script acting crazy after upgrade to QV12

Thu, 24 Mar 2016 06:38:20 GMT

Hi Guys,

I have recently upgraded QV Desktop and QV server from V11 to V12.

I have noticed a really strange behaviour While re-loading documents.

Problem : When I use Left Join Load, then it loads everything from the second table instead of loading matching data.

Example Script

Load OrderID,

CustomerID,

OrderStatusID

From Order.QVD

WHERE OrderStatusID = '2' ; // this is only loading completed orders //

Left Join Load CustomerID,

CustomerName

FROM Customer.QVD ;

So in this script.. Only those customers will be loaded which exists in the order table.. but instead of that.. it is loading every customer from the customer table.

In Version 11 it was working fine but I have no idea why its loading every row from Customer Table.

Am I doing anything wrong ?

Re: Load Script acting crazy after upgrade to QV12

tresB — Thu, 24 Mar 2016 06:42:40 GMT

Could you post a small representative qvw that demonstrates the issue?

Re: Load Script acting crazy after upgrade to QV12

avinashelite — Thu, 24 Mar 2016 06:44:55 GMT

It really Strange !!! I never faced such things

could please share sample data and your complete script ?? so that we can help you out

Re: Load Script acting crazy after upgrade to QV12

jagan — Thu, 24 Mar 2016 06:51:45 GMT

Hi,

Try

Customers:

Left Keep(Orders)

LOAD

FROM Customer.QVD ;

Regards,

jagan.

Re: Load Script acting crazy after upgrade to QV12

Thu, 24 Mar 2016 10:58:10 GMT

Hi Guys,

I have tried Left Keep too..

I am unable to share that qvw due to the data being confidential but I will replicate the script and data-model and upload it here tomorrow.