topic Re: How to write a qlikview load script for a sql query? in QlikView

How to write a qlikview load script for a sql query?

Sat, 10 May 2014 14:55:43 GMT

Hi all

I loaded two two excel sheets into qlikview application. i need a qlik view load script for the below sql query

please help me

Select COUNT(*) from T1 FULL OUTER JOIN T2 ON T1.Customer=T2. Customer WHERE T1.Customer is not NULL and T2.Customer is not NULL

Re: How to write a qlikview load script for a sql query?

nagaiank — Sat, 10 May 2014 16:28:56 GMT

Try the following script.

TableName:

SQL Select COUNT(*) as CustomerCount from T1 FULL OUTER JOIN T2 ON T1.Customer=T2. Customer WHERE T1.Customer is not NULL and T2.Customer is not NULL;

Re: How to write a qlikview load script for a sql query?

Joseph_Musekura — Sat, 10 May 2014 16:44:17 GMT

Hi,

Please check these two links. They give an understanding of JOINs from both QlikView and SQL perspectives. There is a slight difference with these 2 concepts.

QlikView:

http://community.qlik.com/message/166044#166044

and SQL:

http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/

Regards,

Re: How to write a qlikview load script for a sql query?

swuehl — Sat, 10 May 2014 16:48:42 GMT

You would need to connect to your database using a CONNECT statement (which you can create using the wizard on Data tab of the script editor). Take care to create a data source in your Windows administration first.

Then you can create a LOAD / SELECT statement (as shown above or using the wizard on data tab).

Re: How to write a qlikview load script for a sql query?

Sun, 11 May 2014 10:10:37 GMT

Thank you Swuehl..

But i loaded those two tables through excel ,but i need to perform that condition on excel data for that i need qv script help me..

Re: How to write a qlikview load script for a sql query?

its_anandrjs — Sun, 11 May 2014 11:13:23 GMT

By excel file you can perform the SQL logic or scripts like below script similar to the SQL script.

SQL Select COUNT(*) as CustomerCount from T1 FULL OUTER JOIN T2 ON T1.Customer=T2. CustomerWHERE T1.Customer is not NULL and T2.Customer is not NULL;

T1:

Load *,Customer

From location where not Isnull(Customer);

Outer Join

T2:

Load *,Customer

From Location where not Isnull(Customer);

Left Join

FinalTable:

Load

Count(Customer) as CustomerCount

Resident T1;