Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Can i add two columns together using column names?

Hi

C1,C2,C3

10,20,[C1]+[C2]=30

 

This works in QV, can we do something similar in QS

 

 

2 Solutions

Accepted Solutions
abhijitnalekar
Specialist II
Specialist II

Hi @D19PAL ,

 

You can write expression like

Column(1)+column(2)..

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

MayilVahanan

Hi 

Try like below

Load *,C1+C2 as C3 inline

[

C1,C2

10,20

];

o/p:

MayilVahanan_0-1636537465526.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @D19PAL,

Are you looking for the same to be done on the table or script?

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
D19PAL
Creator II
Creator II
Author

Table

tresesco
MVP
MVP

It should ideally work in similar way in qs as well. If if you are facing issues, please elaborate.

abhijitnalekar
Specialist II
Specialist II

Hi @D19PAL ,

 

You can write expression like

Column(1)+column(2)..

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
D19PAL
Creator II
Creator II
Author

Thanks,

 

How about in the script 

MayilVahanan

Hi 

Try like below

Load *,C1+C2 as C3 inline

[

C1,C2

10,20

];

o/p:

MayilVahanan_0-1636537465526.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.