topic Re: hi, in QlikView

hi,

Tue, 15 Apr 2014 15:36:20 GMT

I have a problem loading my data in Qlikview! Indeed, my data are cross tables but excels except when I load they not show me the real data?

Re: hi,

maxgro — Tue, 15 Apr 2014 15:45:33 GMT

post your qlik doc with the problem

or (guess) read here for crosstable load

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

Re: hi,

its_anandrjs — Tue, 15 Apr 2014 16:06:50 GMT

Load your excel as Crosstable or read the reference manual

Re: hi,

Greg_Williams — Tue, 15 Apr 2014 16:29:03 GMT

When loading data from Excel, sometimes spreadsheets are not always straight-forward, in other words, they do not always store data in columns. Instead, I have found that customers will add spaces, transpose columns and rows, add text (not really data), and the like. To overcome these issues, QlikView possesses a wizard, Enable Transformation Step. You can access this from within the QlikView Edit Script > Table Files > select your Excel (xls, or xlsx), then select the Next button. This will expose the Enable Transformation Step button. The Transformation Wizard will guide you on how to restructure or define how QlikView should interpret your spreadsheet data structure. Truth be told, this does take some getting use to, so you might have to run through it more than once to get a feel for what it is attempting to accomplish, then make any necessary enhancements.

Hope this Helps you.

~Greg