topic Re: Cross Table in QlikView

Cross Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

[Kostenstellkosten]:

CrossTable(Month, Kosten,2)

LOAD [Kostenstelle],

[Kostenart],

[43009],

[43040],

[43070],

[43101],

[43132],

[43160],

[43191],

[43221],

[43252],

[43282],

[43313],

[43344]

FROM [lib://AttachedFiles/KostenSAP.xlsx]

(ooxml, embedded labels, table is Kostenstellkosten);

Final:

Load Kostenstelle,

date(num#(purgeChar(Month,'"'),'00000')) as Month,

Kosten,

Kostenart

Resident [Kostenstellkosten];

Drop Table [Kostenstellkosten];

Could you please explain, why my file is not uploaded in this format? If i upload it without 'Kostenart' (see below), it is working, In my Final File i would like to more than just Kostenstelle, Kosten & Month.

Final:

Load Kostenstelle,

date(num#(purgeChar(Month,'"'),'00000')) as Month,

Kosten,

Resident [Kostenstellkosten];

Drop Table [Kostenstellkosten];

Thank you in advance

Re: Cross Table

sunny_talwar — Fri, 27 Jul 2018 16:32:26 GMT

Try this

[Kostenstellkosten]:

CrossTable(Month, Kosten,2)

LOAD [Kostenstelle],

[Kostenart],

[43009],

[43040],

[43070],

[43101],

[43132],

[43160],

[43191],

[43221],

[43252],

[43282],

[43313],

[43344]

FROM [lib://AttachedFiles/KostenSAP.xlsx]

(ooxml, embedded labels, table is Kostenstellkosten);

Final:

NoConcatenate

Load Kostenstelle,

date(num#(purgeChar(Month,'"'),'00000')) as Month,

Kosten,

Kostenart

Resident [Kostenstellkosten];

Drop Table [Kostenstellkosten];

Re: Cross Table

Anonymous — Mon, 06 Aug 2018 06:31:53 GMT

Thank you!