topic Re: Crosstab in QlikView

Crosstab

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Hey all I need to Crosstab a table here is a similar example of my current situation noting that in my real case I have more date:

current Table:

Output:

sunny_talwar — Wed, 29 Mar 2017 11:16:16 GMT

May be try this

Table:

LOAD * INLINE [

ID, Date, Status

1, 01/01/2017, Open

2, 01/01/2017, Intiated

3, 01/01/2017, Closed

1, 02/01/2017, Closed

2, 02/01/2017, Open

3, 02/01/2017, Closed

];

FinalTable:

LOAD Distinct ID

Resident Table;

FOR i = 1 to FieldValueCount('Date')

vField = FieldValue('Date', $(i));

Left Join (FinalTable)

LOAD ID,

Status as [$(vField)]

Resident Table

Where Date = '$(vField)';

NEXT

DROP Table Table;

MarcoWedel — Wed, 29 Mar 2017 11:44:00 GMT

Hi,

a (not recommended) script solution would be:

table1:

Generic

LOAD ID,

Date,

Status

FROM [https://community.qlik.com/thread/255167] (html, codepage is 1252, embedded labels, table is @1);

If you just want to present your output table in the front end, then you could use a pivot table, leaving your source table structure as is:

hope this helps

regards

Marco