topic Re: Cross Table in QlikView

Cross Table

NavinReddy — Thu, 15 Aug 2013 06:20:34 GMT

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 — Thu, 15 Aug 2013 06:42:37 GMT

hi attach is what you asked for

Gysbert_Wassenaar — Thu, 15 Aug 2013 06:48:43 GMT

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 — Thu, 15 Aug 2013 07:04:06 GMT

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 — Thu, 15 Aug 2013 08:01:34 GMT

Thank you all