topic Re: Transformation of Table in QlikView

Transformation of Table

Wed, 25 Mar 2015 14:48:27 GMT

Hi Team,

I want to convert table1 into table2. Please help.

Table1:

Student	Paper-I	Paper-I	Paper-I	Paper-II	Paper-II	Paper-II	Paper-III	Paper-III	Paper-III	Paper-IV	Paper-IV	Paper-IV
Type	External	Internal	Practical	External	Internal	Practical	External	Internal	Practical	External	Internal	Practical
A	41	33	32	37	31	39	39	32	37	43	30	45
B	39	34	47	31	29	44	38	33	47	45	37	49
C	28	27	37	32	29	44	38	32	44	28	31	48
D	36	32	47	44	35	49	34	31	47	29	27	45

Table2:

Student Name	Paper	Type	Marks
A	Paper-I	External	41
A	Paper-I	Internal	33
A	Paper-I	Practical	32
A	Paper-II	External	37
A	Paper-II	Internal	31
A	Paper-II	Practical	39
A	Paper-III	External	39
A	Paper-III	Internal	32
A	Paper-III	Practical	37
A	Paper-IV	External	43
A	Paper-IV	Internal	30
A	Paper-IV	Practical	45

Regards

Priyanka

Re: Transformation of Table

Wed, 25 Mar 2015 14:52:24 GMT

Hi,

It can possible with cross table.

Re: Transformation of Table

buzzy996 — Wed, 25 Mar 2015 14:58:20 GMT

try this,simply load ur table1 data in qlikview.

use cross table.

move ur columns as rows

Re: Transformation of Table

awhitfield — Wed, 25 Mar 2015 15:42:15 GMT

Hi Priya,

you should check out the following post, which has some pretty useful examples:

http://community.qlik.com/thread/64678

Cheers Andy

Re: Transformation of Table

Wed, 25 Mar 2015 16:41:55 GMT

Hi Priya,

you can use cross table function or you can attach your file so i can work on that and send back to you.

Re: Transformation of Table

maxgro — Wed, 25 Mar 2015 20:30:35 GMT

it seems ok

CrossTable(Student, Marks, 2)

LOAD Student as F1,

Type,

A, B,

C, D

FROM

[http://community.qlik.com/thread/157623]

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

Transpose()

));

Re: Transformation of Table

Thu, 26 Mar 2015 09:27:51 GMT

Hi Massimo,

Thanks for your reply.

Can you help me with the solution.

please find attached sample file.

Thanks in advance

Regards,

Priyanka