Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiply by 100 in a component tMap

Hello
 

I have 2 lines and several columns. All are in double in the fileinputExcel.

List1   Column A        Column B          Column C

Number    145,25               254,12           54,94

%               0,331                0,154             0,504

 

I only want to multiply the line with % by 100. So, in the fileOutputExcel, i want see : 

List1   Column A        Column B          Column C

Number    145,25          254,12               54,94

%               33,1              15,4                 50,4

 

I tried to use the component tMap but it multiply all the columns (Number and %).

 

I don't how to do

 

Thanks in advance

Labels (2)
3 Replies
vapukov
Master II
Master II

You could use IF condition, something like:

 

 

row1.List1.equals("%")?row1.ColumnA*100:ColumnA

(of course same for all columns)

 

Anonymous
Not applicable
Author

Yes, i know. I had a little problem with posts.

Thank a lot.