topic Re: Need help in Transforming Dimensions in QlikView

Need help in Transforming Dimensions

Sun, 14 Oct 2012 13:46:02 GMT

Dear,

Community.

Scenario:

How can i use cross table function to make 4 dimensions as One Dimension. and similarly next four dimensions as another dimension.

please see the attach files.

what would be the best approch to full fill the requirment.

whiteline — Sun, 14 Oct 2012 16:11:38 GMT

Hi.

Just rearrange your fields in a load statement and use two separate loads:

(ID is used as a key to connect the tables)

Crosstable([Consultancy], [Consultancy Value], 9)

LOAD

rowno() as ID,

Depatment,

Designation,

[Hiring Target],

[YTD Offers Extended],

[Rejected Offers],

Drops,

[Pending Offers],

[Outstanding Offers],

[Consultancy A],

[Consultancy B],

[Consultancy C],

[Consultancy D]

FROM

(ooxml, embedded labels, table is Data);

Crosstable([In Processing Consultancy], [In Processing Consultancy Value], 1)

LOAD

rowno() as ID,

[In Processing Consultancy A],

[In Processing Consultancy B],

[In Processing Consultancy C],

[In Processing Consultancy D],

FROM

(ooxml, embedded labels, table is Data);

Mon, 15 Oct 2012 12:19:54 GMT

Dear,

Thanks it works like a charm.

Thanks,

Mukram.