topic Re: crosstbale function use in QlikView

crosstbale function use

Mon, 13 Apr 2015 10:28:30 GMT

Dear all

I has an table like the below

project	ticketID	key	value
10001	ticket001	downAA	1
10001	ticket001	downBB	2
10001	ticket002	downAA	3
10001	ticket002	downBB	5

i want to get the result table like the below show

project	ticketID	downAA	downBB
10001	ticket001	1	2
10001	ticket002	3	5

can i use the crosstable or other QV function to realize this directly.

Re: crosstbale function use

ashfaq_haseeb — Mon, 13 Apr 2015 10:31:58 GMT

Hi,

Check this

The Generic Load

Regards

ASHFAQ

Re: crosstbale function use

Mon, 13 Apr 2015 10:33:00 GMT

hi,

you can use pivot table in front end for this.

Regards

Vimlesh

Re: crosstbale function use

Anonymous — Mon, 13 Apr 2015 10:35:46 GMT

you can directly load pivot table

Thanks

BKC

Re: crosstbale function use

Mon, 13 Apr 2015 10:51:41 GMT

thanks for your reply,but i am not want to show this data in the front, else do the transform on the qv script, is there any QV function to do this directly?