topic Modify table according to value list in QlikView

Modify table according to value list

capriconuser — Thu, 14 Mar 2019 05:05:19 GMT

I have a table like this

name	a_col sum	a_col count	b_col sum	b_col
	20541	46	68560	149
a	3141	9	2139	6
b	8400	21	10846	29
c	9000	16	55575	114

now i want this table like this

name trans count sum

a reserved a_col 9 68560

b_col 6 2139

here i want to add reserved in value list like i want to create dummy one same goes for count and sum

.. not be suppose to come from table

so how i structure of modify table like above ?

Re: Modify table according to value list

mdmukramali — Thu, 14 Mar 2019 05:22:52 GMT

Hi,

have to try with Cross Table concept in the Script level?

Re: Modify table according to value list

capriconuser — Thu, 14 Mar 2019 05:26:17 GMT

no.. i dont have idea cross table.. and i dont want to create cross table in script level ..

there is
valuelist ('Count','Sum')
now i want expression of count and sum according to these like this

count sum
a_col //here should be values according to count and sum
b_col

hope you understand..

Re: Modify table according to value list

capriconuser — Thu, 14 Mar 2019 06:25:30 GMT

any help please