topic Cross Table Help in QlikView

Cross Table Help

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Please find the attached document,

Need Help on the arrangement of data in Cross table.

Please check the excel data contains 2 dimensions and 3-3 common data.

I want data like below

Dept Profit centre Date Units Total Cost

Please help me

Re: Cross Table Help

qlikview979 — Fri, 15 Jul 2016 09:29:58 GMT

Hi,

Please find the attached document .

May be this.

Re: Cross Table Help

Fri, 15 Jul 2016 09:34:49 GMT

Thanks for your prompt reply,

attached file contains only one date only but i Need all dates in the excel file.

Please help ..

Regards

Surender

Re: Cross Table Help

sunny_talwar — Fri, 15 Jul 2016 10:06:53 GMT

May be try this:

Table:

CrossTable(Header, Value, 2)

LOAD *

FROM

[Sample Excel.xlsx]

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD DISTINCT

RowNo() as Key,

Dept,

[Cost Centre],

Value as Date

Resident Table

Where Header LIKE 'Date*';

Join(FinalTable)

LOAD DISTINCT

RowNo() as Key,

Dept,

[Cost Centre],

Value as Units

Resident Table

Where Header LIKE 'Units*';

Join(FinalTable)

LOAD DISTINCT

RowNo() as Key,

Dept,

[Cost Centre],

Value as [Total Cost]

Resident Table

Where Header LIKE 'Total Cost*';

DROP Table Table;

Re: Cross Table Help

Fri, 15 Jul 2016 10:50:05 GMT

Thanks Sunny,

Regards,

Surender