Sqlserver with qlikview

[#1]

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

[Yousef_Amarneh]

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

[#3]

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.

[Yousef_Amarneh]

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

[#5]

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

[#6]

Thank u so much i got clarified the doubt