topic Best way to load excel data in QlikView

Best way to load excel data

Fri, 02 Sep 2011 18:30:51 GMT

Hi,

I have some data which is in an odd format.(see attached)

I'm thinking that it may need a Crosstable load, but I'm not sure.

It contains the fields : Question ; QuestionDesc ; Group Excl ; Group Incl

Any suggestions or ideas on how to load this into Qlikview would be appreciated.

Thanks!

Best way to load excel data

Sat, 03 Sep 2011 01:05:25 GMT

Ideas?

Best way to load excel data

Sat, 03 Sep 2011 07:44:14 GMT

beanz,

i saw ur data its not a crosstable i am sure.

can u explain what result u want from this data?

thanks
Harlin

Best way to load excel data

its_anandrjs — Sat, 03 Sep 2011 08:00:19 GMT

Hi,

I dont thing you need to create a crosstable you exclude any blank rows in load script or in any object level also. Or if you want to create a crosstable it is also good technique to use it, but you need to use data according to cross table after creation.

Regards

Anand

Best way to load excel data

its_anandrjs — Sat, 03 Sep 2011 08:03:36 GMT

Hi Beanz,

If you want to create a Crosstable create a crosstable like

Data:

CrossTable(QuestionDesc, Data)

LOAD Question,

QuestionDesc,

[Group Excl],

[Group Incl]

FROM

[sample data.xlsx]

(ooxml, embedded labels, table is Sample);

And check the result.

Best Regards,

Anand

Re: Best way to load excel data

Mon, 05 Sep 2011 06:20:07 GMT

Hi,

Please see if the attached can help you.

Cheers.

Re: Best way to load excel data

SunilChauhan — Mon, 05 Sep 2011 06:55:18 GMT

may be like this u want

see the attached file(on Backrocks credit )