Cross Table

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

Hello All,

I have a Excel Table in the below Format, and i would like to Convert this and save the Dates as a Seperate Column.

I know about Cross Table but, somehow struggling to get the Dates from this format. Attaching sample data and app.

TIA!!

Re: Cross Table

sunny_talwar — Tue, 12 Jun 2018 14:11:44 GMT

Try this

Table:

CrossTable(Date, Quantity)

LOAD F1 as Material,

[01.2016],

[02.2016],

[03.2016],

[04.2016],

[05.2016],

[06.2016],

[07.2016],

[08.2016],

[09.2016],

[10.2016],

[11.2016],

[12.2016],

[01.2017],

[02.2017],

[03.2017],

[04.2017],

[05.2017],

[06.2017],

[07.2017],

[08.2017],

[09.2017],

[10.2017],

[11.2017],

[12.2017],

[01.2018]

FROM

Quantity.xlsx

(ooxml, embedded labels, table is DF_GRID_1)

Where F1 <> 'Material';

FinalTable:

NoConcatenate

LOAD Material,

Date#(Date, 'MM.YYYY') as Date,

Quantity

Resident Table;

DROP Table Table;

topic Re: Cross Table in QlikView

Cross Table

Re: Cross Table