Help on loading data from Excel

Anonymous — Wed, 28 Jul 2010 05:55:51 GMT

Hi All,

As I dig deeper in QlikView, I find a growing interest and several questions regarding the same.

I have to develop a prototype dashboard which has several charts - each chart having a table with a few (<10) rows. The underlying data model is maintained in Excel.

Now, one way of doing this is - having a separate worksheet per table, which increases the number of sheets. Is there a way to maintain several small tables in a single Excel worksheet (one tab of an Excel spreadsheet) and load it in QlikView? This may seem non-standard and against design principles, but suffices for the prototype development requirements and increases maintainability.

Second requirement is regarding breaking the associative linking in QlikView. One way of doing it by changing the column names, but are there other ways of doing it?

Third requirement - any guide on best practices in QlikView?

Regards

Amit

Help on loading data from Excel

manishkumar75 — Wed, 28 Jul 2010 06:53:49 GMT

Hi,

For the first requirement you can go for "Enable Transformation".

For the second requirement, in order to break the associative linking you can use "Qualify".

For any guide on best practices you can refer http://www.quickqlearqool.nl/

Regards,

Manish

Help on loading data from Excel

Tue, 10 Aug 2010 16:29:27 GMT

hi,

You can use in Edit script and clik on file table

After you can modify options

topic Help on loading data from Excel in QlikView

Help on loading data from Excel

Help on loading data from Excel

Help on loading data from Excel