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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Values of a line multiply by 100 (And not columns, just line)

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)
2 Replies
Anonymous
Not applicable
Author

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

Thank a lot.