topic Re: New to QlikView in QlikView

New to QlikView

Sat, 19 Apr 2014 12:08:47 GMT

I am new to Qlik View , i want to learn from scratch that how to use Qlik View and how to connect to databases.

Re: New to QlikView

its_anandrjs — Sat, 19 Apr 2014 12:11:49 GMT

Try to post the question on the community then the members will help you for the qlikview related problems. And also if you refer the reference manual is also very best read the reference manual and having any problem post the question on the community then any members will help you.

Thanks

Re: New to QlikView

its_anandrjs — Sat, 19 Apr 2014 12:13:54 GMT

For connect to the data base you have to use connection string weather it will ODBC, PLE DB or third party connection tool from that you can connect qlikview to the databases.

Re: New to QlikView

Sat, 19 Apr 2014 12:14:33 GMT

OK thank you

Re: New to QlikView

MK_QSL — Sat, 19 Apr 2014 12:16:19 GMT

Which database?

SQL Server...

Go to Edit Script

Select Database OLE DB

Connect

Select Provider >> Microsoft OLE DB Provider for SQL Server >> Next

Select or Enter Your Server Name

Add UserName and Password

Select Database

Test Connection >> Make Sure Database connection should be successful.

Now Go to Edit Script again

Select (Below Connect)

Now Select Table and Fields....

Re: New to QlikView

Sat, 19 Apr 2014 12:16:48 GMT

I have to learn Qlik View from scratch for that the reference manual will be sufficient?? And how to create sample databases??? Are there are any sources??

Re: New to QlikView

MK_QSL — Sat, 19 Apr 2014 12:17:56 GMT

Go to Edit Script

Insert >> Test Script...

Re: New to QlikView

its_anandrjs — Sat, 19 Apr 2014 12:20:45 GMT

Steps to follow to connect to the databases

1. If it is flat files ,excel files, csv files etc then direct load the table files and use load wizard.

2. If data base in MsAccess, SQL Server, Oracle etc then make ODBC string and then loads table availble in the data base by the connection string

EG:- ODBC CONNECT TO [MS Access Database;DBQ=D:\t1.accdb];

then follwed by the table load statements.

3. If database is third party then use the connector provided by the Qliktech and use that connector to connect the database and then same use the connection string followed by the table load statement.

Regards

Re: New to QlikView

swuehl — Sat, 19 Apr 2014 12:27:26 GMT

Arul,

this content is copyrighted, as you can see from the statement on page 3:

system, or transmitted in any form or by any means, without the prior written

permission of the publisher, except in the case of brief quotations embedded in

critical articles or reviews."

I assume you don't have the written permission, so please remove the attachment.

Thanks,

Stefan

Re: New to QlikView

MK_QSL — Sat, 19 Apr 2014 12:29:24 GMT

Arul, remove this immediately, otherwise your account possibly would be banned....

Re: New to QlikView

Sat, 19 Apr 2014 12:49:27 GMT

I have done edit script then test script then after that in the databases what i have to choose??odbc,ole db???

By this script what will happen?? what does this script indicates??

Re: New to QlikView

its_anandrjs — Sat, 19 Apr 2014 13:02:18 GMT

If you select ODBC and then database >> data source >> suppose you select (Ms access Database) >> then select its location and file name and ok you get connection and then select the database file >> you can load views, tables etc.

Re: New to QlikView

swuehl — Sat, 19 Apr 2014 13:05:36 GMT

If you inserted the test script from the menu in edit script, just hit reload button.

No need to use an external source for the test script, all data is created by the script itself.

The test script just creates a very simple data model with some dimensions and measure, but it's enough to start creating some simple charts.

Re: New to QlikView

arulsettu — Sat, 19 Apr 2014 13:15:33 GMT

ok thanks guys

Re: New to QlikView

Sat, 19 Apr 2014 13:24:05 GMT

thank you all..