Help on loading data from Excel

[Anonymous]

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

[manishkumar75]

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

[#3]

hi,

You can use in Edit script and clik on file table

After you can modify options