topic Re: crosstable help in QlikView

crosstable help

arusanah — Wed, 01 Jun 2016 19:42:02 GMT

I have a sheet where I need to change column2-6 to rows . and column 1 as column header for all 5 columns.

attached is sample data file. can somebody help writing cross table () . pls

sunny_talwar — Wed, 01 Jun 2016 19:43:12 GMT

I don't see anything attached.

arusanah — Wed, 01 Jun 2016 20:05:11 GMT

somehow not letting me edit my query. I have attached a screen shorty of data

sunny_talwar — Wed, 01 Jun 2016 20:09:21 GMT

What is the output you are expecting to see?

arusanah — Wed, 01 Jun 2016 20:14:52 GMT

output should be like this

arusanah — Wed, 01 Jun 2016 20:16:03 GMT

ignore 2 's at end

sunny_talwar — Wed, 01 Jun 2016 20:20:12 GMT

Try this:

Table:

LOAD [person ID],

month,

uid,

pwd,

year

FROM

[https://community.qlik.com/thread/219215]

(html, codepage is 1252, embedded labels, table is @1, filters(

Transpose()

));