Cross Table

[NavinReddy]

Hi All,

Could some one help to Do this,

Cross table how to do this in Qlikview

Plz find Excel Data

Im Using Personal Edition

Thanks in Advace

Rohit

[lironbaram]

hi attach is what you asked for

[Gysbert_Wassenaar · Accepted solution]

Since he's using QV Personal Edition:

LOAD date(SALES_DATE) as SALES_DATE,

     SALES_PERSON,

     REGION,

     SALES

FROM Sales.xlsx

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

Transpose()

))

WHERE(IsNum(SALES_DATE));

[jagan]

Hi Rohit,

Use below script to transpose the data

Data:

LOAD SALES_DATE,

     SALES_PERSON,

     REGION,

     SALES

FROM

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

Remove(Col, Pos(Top, 2)),

Transpose()

));

Hope it helps you.

Regards,

Jagan.

[NavinReddy]

Thank you all