Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikhil2725
Creator II
Creator II

Addition

Hi Team,

I have a below table.

PH6PH6_descSales T/O
231546BV 5461163729
255373VAG Produkte1092099
221051El. fusion fitti. PB880487
201950Solv.cement fitt.me.874874
230152Solv. Cement Fit. mm689215
202956Ballvalves for water550592
230153Adapter Fittings mm531082
251313ELGEF Plus saddles464251
221043Pipe PB in bars451753
2J1J54Regulierarmaturen432843

 

Further I want to add new column as below. Kindly help me in doing this.

PH6PH6_descSales T/ONew ColumnDescription
231546BV 54611637291163729For the first row the value should be same as Sales T/O(1163729)
255373VAG Produkte10920992255828Addition of 1st row and 2nd row of Sales T/O(1163729+1092099)
221051El. fusion fitti. PB8804873136315880487+2255828
201950Solv.cement fitt.me.8748744011189874874+3136315
230152Solv. Cement Fit. mm6892154700404689215+4011189
202956Ballvalves for water5505925250996550592+4700404
230153Adapter Fittings mm5310825782078531082+5250996
251313ELGEF Plus saddles4642516246329464251+5782078
221043Pipe PB in bars4517536698082451753+6246329
2J1J54Regulierarmaturen4328437130925432843+6698082

 

 

40 Replies
Nikhil2725
Creator II
Creator II
Author

Hey Thanks,

But can we hide that whole column????