topic Problem in transpose data in script. in QlikView

Problem in transpose data in script.

vijayit43 — Mon, 13 Apr 2015 05:10:22 GMT

Hi Expert,

In Excel Data are this type..

	Assign User
QV Name	Dashboard1	Dashboard2	Dashboard3	Dashboard4	Dashboard5	Dashboard6
	User1	User1	User2	User1	User2	User1
	user2	user3	user3	user3	user4	user2
	user3	user4	user4	user4	user5	user4

But when we load script then we want data at this type.

How to achieve this please suggest..

Mon, 13 Apr 2015 05:20:33 GMT

crosstable (QVName, User)

load * inline

[

Dashboard1, Dashboard2, Dashboard3 ,Dashboard4, Dashboard5 ,Dashboard6

User1,User1, User2 ,User1 ,User2, User1

user2, user3 ,user3, user3 ,user4, user2

user3, user4, user4, user4 ,user5 ,user4

];

SergeyMak — Mon, 13 Apr 2015 05:25:29 GMT

You need to use crosstable function

Try this script

CrossTable ('QV Name','Assign User',1)

LOAD 1 AS Tmp, * INLINE [

Dashboard1,Dashboard2,Dashboard3,Dashboard4,Dashboard5,Dashboard6

User1,User1,User2,User1,User2,User1

user2,user3,user3,user3,user4,user2

user3,user4,user4,user4,user5,user4

];

DROP Field Tmp;

Regards,

Sergey

vijayit43 — Mon, 13 Apr 2015 05:34:52 GMT

how to fetch from excel.

SergeyMak — Mon, 13 Apr 2015 05:38:03 GMT

Just load data from excel as usual and add these lines before

CrossTable ('QV Name','Assign User',1)

LOAD 1 AS Tmp, * ;

And this line after your load from excel

DROP Field Tmp;