topic Re: How to Load this excel Data into a Meaningful Format (Pivot Table) in QlikView

How to Load this excel Data into a Meaningful Format (Pivot Table)

techvarun — Wed, 04 Feb 2015 14:56:26 GMT

Hi Qlikxperts

Please help me out to load the attached excel sheet into a meaningful format

Thanks

Varun

Re: How to Load this excel Data into a Meaningful Format (Pivot Table)

marcus_sommer — Wed, 04 Feb 2015 16:07:46 GMT

You will need several steps to load these excel:

- for each data-area (EXPENDITURE + ASSET REPLACEMENTS) an own load

- use the header-option in load-statement

- filter out unneeded records per where-clause

- fill missing cell-values with peek() or previous

- perform a crosstable load to transform the data into a data-stream

Have a look on these links as a starting-point for you:

http://community.qlik.com/message/382931#382931

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/08/peek-vs-previous-when-to-use-each

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

- Marcus

Re: How to Load this excel Data into a Meaningful Format (Pivot Table)

marcus_sommer — Thu, 05 Feb 2015 10:56:21 GMT

In addition many transformation-steps could be done with the qv table-wizard. Unfortunately there is nearly nothing about it within the documentation - but in QlikView 11 for Developers could you find some examples to load unstructured data.

QlikView 11 for Developers

Barry Harmsen und Miguel Garcia

ISBN-13: 978-1849686068

- Marcus