Can we pivite the table using qv script?

[pkkushwaha]

Hi,

I am facing below problem:

base table

sid	name	sub	marks
1	a	phy	34
3	c	math	34
1	a	chem	35
2	b	chem	35
2	b	math	35
1	a	math	36
2	b	phy	45
3	c	chem	45
3	c	phy	54

o/p table

name	sid	sub	chem	math	phy
a	1		35	36	34
b	2		35	35	45
c	3		45	34	54

above output is possibe using pivote but due to huge amount of data (10,000,000) pivote chart option is not good.

Can we do same pivote using qv scripting?

[sbaldwin]

Hi this sounds like i similar problem i saw a while back, take a look at this post :

http://community.qlik.com/message/142210