topic Re: Pivot Table in QlikView

Pivot Table

Mon, 27 Aug 2012 09:47:02 GMT

Hi,

I have a requirement which may sound simple.. but I am not able to get it right...

Below in my data:

id	loc	time	code	text	number
123	abc	2:00 PM	12	dfg	1
123	abc	11:30 PM	45	dxf	2
123	abc	4:00 AM	33	xcvbn	3
123	abc	3:30 PM	67	vb n	4
123	abc	1:00 PM	98	bnh	5
123	abc	2:45 PM	24	bnhghj	6
234	ghy	3:30 PM	24	hgj	7
234	ghy	1:00 PM	33	gbn	8

and the format in which i need it is:

code1

text1

number1

time1

code2

text2

number2

time2

code3

text3

number3

time3

id1

loc1

id2

loc2

id3

loc3

draggin the blue line gave me 4 different rows... any ideas please..

Regards...

Re: Pivot Table

Anonymous — Mon, 27 Aug 2012 10:25:13 GMT

Hi, create three dimensions in your pivot (id, loc and number). And then pivot the number-dimension up over your expressions; code, text and time. Regards, Sander

Re: Pivot Table

Mon, 27 Aug 2012 11:31:47 GMT

can you please post an example...

Re: Pivot Table

Anonymous — Mon, 27 Aug 2012 11:48:30 GMT

Hi, see attached. Regards, Sander

Re: Pivot Table

Tue, 28 Aug 2012 04:37:42 GMT

thank you.. this is how i wanted it but sorry to ask another question, if i do not want number field in the table.. then what is the alternative?

Re: Pivot Table

Tue, 28 Aug 2012 08:14:04 GMT

any ideas ??

Re: Pivot Table

Anonymous — Tue, 28 Aug 2012 08:36:10 GMT

Hi, you need a unique key here. Skipping 'number' means that you'll have to define another id. Else revert back to a plain table box. Regards, Sander