Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dennysetiawan
Partner
Partner

Advance Transpose Case

Hi Community,

I have a table like this:

Qst_MTM_source.jpg

I want to transpose that table, so my expectation output should be like this:

Qst_MTM_expect.jpg

Could you show me the best practice or script solution to have an output like above?

Herewith I attach my source data.

Thank you.

1 Reply
sunny_talwar

Try this

Table:

CrossTable(DATE, VALUE, 5)

LOAD PRODUCT,

    RANGE,

    FOB,

    Port,

    MTM,

    [42737.000000],

    [42738.000000],

    [42739.000000],

    [42740.000000],

    [42741.000000],

    [42744.000000],

    [42745.000000]

FROM

[..\..\Downloads\Qst_MTM.xlsx]

(ooxml, embedded labels, table is Source, filters(

Transpose()

));


FinalTable:

NoConcatenate

LOAD PRODUCT,

Date(RANGE) as RANGE,

FOB,

Port,

MTM,

Date(Num#(DATE)) as DATE,

Num(VALUE) as VALUE

Resident Table;


DROP Table Table;


Capture.PNG