Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

capriconuser
New Contributor III

Modify table according to value list

I have a table like this 

 

namea_col suma_col countb_col sumb_col
 205414668560149
a3141921396
b8400211084629
c90001655575114


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 ?

3 Replies
Highlighted
mdmukramali
Valued Contributor III

Re: Modify table according to value list

Hi,

have to try with Cross Table concept in the Script level?
capriconuser
New Contributor III

Re: Modify table according to value list

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..
capriconuser
New Contributor III

Re: Modify table according to value list

any help please