Hello!!! This is my Second day on Qlik ..my question is , can i get report using my Oracle database Server? if yes, pls. let me know the procedure...its urgent please

[rahulhv1]

Hello!!! This is my Second day on Qlik ..my question is , can i get report  using my Oracle database Server? if yes, pls. let me know the procedure...its urgent please

[bbi_mba_76]

Hi,

I don't understand so much. You could use oracle db as source for your qlikview report.

Just create a connection to the db

and then write your select, ie

SQL select * from dual;

[rahulhv1]

Thankx BBI,

I guess i need to buy lic. for this first as right now i am working on free personal version and in this version there might not be the tool take data from data base. Could you please help to to generate data from xls file pls. where in quantity field is in negative which i need to get ommited automatically as like below example.

ProductName    qty

A                      100

B                       200

C                      -100

A                       -10

In above example, i need prodcut wise sales in which qty < 0 should not be considerd. 

[#4]

Yes you ca get a report. First you have to create a connection with your oracle database server usind ODBC or OLE DB connection options.

[#5]

You should read the tutorial manual for this. It will help  you alot

[#6]

you need to simply create a Connection String by Selecting OLE DB or ODBC in edit Script.

1. before you should install same Oracle Client on your machine.
2. make sure your system is connected in LAN.
3. create a Connection String by Selecting OLE DB or ODBC drop box in edit Script and then click connect.
4. you will find a simple wizard just select client driver go next and put proper Server ID/Database name/Pass and press okay.
5. A connection String will get generate automatically then click Select and find all the tables.

[Michael_Tarallo · Accepted solution]

Hello Rahul - awesome to hear you working with QlikView.

Please check these videos out, it has everything you need to connect to data and to help you get started very quickly with QlikView.

New to QlikView Videos

Also note that the Personal edition allows you to connect to all data. However, the first window that appears is just a wizard to help you get started working with various data files. You can choose to have that turned off in the QliKView Desktop Settings, User Preferences menu.

Regards,

Michael Tarallo

Senior Product Technical Manager

QlikView and QlikView Expressor

Follow me on Twitter @mtarallo

[#8]

Hi rahul try this

TEST:

LOAD [ProductName],

     qty

FROM

(ooxml, embedded labels, table is Sheet1) where qty > 0;

[rahulhv1]

Thanks a lot Mr.Michael, its working fine now. Now just i wanna have some conditional reports e.g. Monthwise/ Customerwise etc. etc. could u please give me a link for tutorial , it would be a great help to me.

Thanks a lot again for ur co-operation.

Regards

Rahul Varma.