Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sqlserver with qlikview

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

5 Replies
Yousef_Amarneh
Partner - Creator III
Partner - Creator III

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

Yousef Amarneh
Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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

Yousef Amarneh
Not applicable
Author

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

Not applicable
Author

Thank u so much i got clarified the doubt