topic Re: New to QlikView in QlikView

New to QlikView

Wed, 24 Apr 2013 16:50:40 GMT

Hello, I am new to QlikView, started the training..

I wanted to know that is there any way that i can load data from a file (csv) into a DataBase(oracle) directly rather than loading it into QlickView?

Are text (.txt) files supported while loading data from files?

I apologize if this is not the right place to post the question, your help is highly appreciated.

Re: New to QlikView

Gysbert_Wassenaar — Wed, 24 Apr 2013 17:23:07 GMT

Ask your Oracle Database Administrator to load your .csv file into an oracle database. Qlikview is not the tool to do that. Qlikview uses its own in-memory database. Qlikview does not store its data in a database managed by a dbms like Oracle or SQL Server.

Text files are supported as a data source for Qlikview.

Re: New to QlikView

its_anandrjs — Thu, 25 Apr 2013 06:59:44 GMT

Hi,

Talk to your Database Developer or Administrator to load that CSV file into oracle it is a best way.

Regards,

Anand

Re: New to QlikView

Thu, 25 Apr 2013 17:45:12 GMT

Thanks for your reply.

Other question i had was, if i load one file, and i want to see the maximum value for a field in the file i just loaded. What are the steps to do so?

for ex: File i loaded has a field called Amount with the following records (12,32,534,21,546,11). Its maximum value is 546. Any way to show the max value / min value for any field in the table?

Re: New to QlikView

Gysbert_Wassenaar — Thu, 25 Apr 2013 18:08:00 GMT

You could try a variant on this. See attached qvw.