topic Re: Multiple Header Cross table load in QlikView

Multiple Header Cross table load

Anonymous — Wed, 18 Mar 2015 12:51:59 GMT

Hi Experts,

I have a source excel file :

Required format :

I want to load this source file into Qlikview as :

I am trying to do this using Crosstable but no success.

Please help

Thanks

BKC

Re: Multiple Header Cross table load

awhitfield — Wed, 18 Mar 2015 13:06:08 GMT

Hi there,

check out this post!

http://community.qlik.com/thread/32556

Look like what you want!!

Andy

Re: Multiple Header Cross table load

buzzy996 — Wed, 18 Mar 2015 13:21:50 GMT

try this,

1. load ur excel data as it is.

2. use pivot table

3. drag ur month column as row,tht will bring ur expected result!

Re: Multiple Header Cross table load

Anonymous — Wed, 18 Mar 2015 13:28:06 GMT

Shiva ,

This will not solve my problem. If I want to sum(Down) for all the month that can not be achieved without loading data in qlikview as given format .

Re: Multiple Header Cross table load

buzzy996 — Wed, 18 Mar 2015 14:04:03 GMT

find attached and change the lable accordingly in rows and columns

Re: Multiple Header Cross table load

Roop — Wed, 18 Mar 2015 15:06:53 GMT

MainSource:

LOAD A,

FROM

Crosstable_Sample.xlsx

(ooxml, no labels, header is 4 lines, table is Sheet2);

CrossTable:

LOAD

A as AppType,

B as AppName,

'01/01/2015' as AppDate,

C as Sched,

D as Avail,

E as AvailPct

Resident

MainSource;

Concatenate LOAD

A as AppType,

B as AppName,

'01/02/2015' as AppDate,

F as Sched,

G as Avail,

H as AvailPct

Resident

MainSource;

Concatenate LOAD

A as AppType,

B as AppName,

'01/03/2015' as AppDate,

I as Sched,

J as Avail,

K as AvailPct

Resident

MainSource;

Concatenate LOAD

A as AppType,

B as AppName,

'01/04/2015' as AppDate,

L as Sched,

M as Avail,

N as AvailPct

Resident

MainSource;

drop table MainSource;