topic Re: Loading data from exel in QlikView

Loading data from exel

Thu, 12 Jun 2014 08:32:31 GMT

Please help,

I cant load correctly data from exel, i dont know ho to correctly configure cross table setings (or maybe i dont need cross table).

Re: Loading data from exel

dharmarasu — Thu, 12 Jun 2014 09:16:16 GMT

hi,

hope this helps you..

in edit script, copy and paste it..

CrossTable(period,value,7)

LOAD MARKET,

CATEGORY,

CLASS,

Manuf,

Brand,

'Fact1' as Fact,

Product,

Period1,

Period2,

Period3,

Period4,

Period5,

Period6,

Period7,

Period8

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

CrossTable(period,value,7)

LOAD MARKET,

CATEGORY,

CLASS,

Manuf,

Brand,

'Fact2' as Fact,

Product,

Period11 as Period1,

Period21 as Period2,

Period31 as Period3,

Period41 as Period4,

Period51 as Period5,

Period61 as Period6,

Period71 as Period7,

Period81 as Period8

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

CrossTable(period,value,7)

LOAD MARKET,

CATEGORY,

CLASS,

Manuf,

Brand,

'Fact3' as Fact,

Product,

Period12 as Period1,

Period22 as Period2,

Period32 as Period3,

Period42 as Period4,

Period52 as Period5,

Period62 as Period6,

Period72 as Period7,

Period82 as Period8

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Dharma

Re: Loading data from exel

Gysbert_Wassenaar — Thu, 12 Jun 2014 09:39:01 GMT

The crosstable function cannot handle multiple horizontal dimensions. You can try separate loads for each fact. See attached qvw.

Re: Loading data from exel

Thu, 12 Jun 2014 10:25:18 GMT

Thanks for fast replays!!

Works fine, but i dont understand some script details..

"1 as Fact" - in my exel it caled Fact1, why you named it 1?

"Period11 as Period1,

Period21 as Period2,

Period31 as Period3,

Period41 as Period4,

Period51 as Period5,

Period61 as Period6,

Period71 as Period7,

Period81 as Period8"

How do i now what number of period is?

Re: Loading data from exel

Gysbert_Wassenaar — Thu, 12 Jun 2014 10:27:16 GMT

A mistake. Change it to 'Fact1' if you need that instead of 1.

Re: Loading data from exel

Thu, 12 Jun 2014 10:45:30 GMT

ok, understand

so what about period numbers?

Re: Loading data from exel

Thu, 12 Jun 2014 12:17:53 GMT

from where you get Period11, Period21, Period 31, etc?

"Period11 as Period1,

Period21 as Period2,

Period31 as Period3,

Period41 as Period4,

Period51 as Period5,

Period61 as Period6,

Period71 as Period7,

Period81 as Period8"

Re: Loading data from exel

Thu, 12 Jun 2014 12:49:48 GMT

Find my self thanks for all, case closed.