topic Re: Sqlserver with qlikview in QlikView

Sqlserver with qlikview

Wed, 04 Dec 2013 10:49:09 GMT

Hi,

I am new to qlikview.suppose i have 15 tables in sqlserver.there any many columns like 14 columns.

My doubt is after getting connected with sql to qlikview we can get the required data and we can perform scripting.but i have large data in sql so i dont want to load the data much.i want to get the data based on some condition would be better because of performnace issue on qlikview.is there any need of script to work on sql to get the data (or) generally loading the tables into qlikview and do scripting which one will generally happens in organisations.

can any body pls help me people who work on sql with qlikview .

Regards

Mahesh

Re: Sqlserver with qlikview

Yousef_Amarneh — Wed, 04 Dec 2013 10:57:52 GMT

your question is not clear please give us more clarifications, but you can use where statement in your script to load specific data.

Re: Sqlserver with qlikview

Wed, 04 Dec 2013 11:01:44 GMT

we can get all 15 tables in qlikview and we can do that work on that data like normal exceldata.but loading unnessarily all the tables and all the recors is will lead to performnce issue right.so i need specified records only in that case i need to write sql queries to retrieve the data or is there any options generally in organisations which way they follow like getting all the tables or getting the specified data.

Re: Sqlserver with qlikview

Yousef_Amarneh — Wed, 04 Dec 2013 11:09:46 GMT

you can use where statement in your load expression, like load * from Sales where year=2013

Re: Sqlserver with qlikview

Wed, 04 Dec 2013 11:20:22 GMT

Hi,

MyTable:

LOAD *;

SQL SELECT X, Y, Z FROM TABLE_SQL1 WHERE .....;

You the SQL you want that is accepted by your database. You use the WHERE statement to get only the data you want.

Fabrice

Re: Sqlserver with qlikview

Wed, 04 Dec 2013 12:29:14 GMT

Thank u so much i got clarified the doubt