Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Specialist III
Specialist III

Hi,

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

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..
Highlighted
Contributor III
Contributor III

any help please