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: 
Kohli
Creator II
Creator II

Addition of two fields

i have two field like

B.Salary, P.F

10000, 1200

50000,  6000

12000,  1240

20000,  2400

i want output like these

B.Salary, P.F,  Totall

10000, 1200, 11200

50000, 6000,  56000

12000,  1240, 14240

20000,  2400,  22400;

Can you please suggest.

2 Replies
Mark_Little
Luminary
Luminary

Hi

In Script

B.Salary+P.F  AS Total,

Front End add an expression

Sum(B.Salary+P.F)

Ideally more information would helpful, i.e. where you want the fields and if they are in the same table within the data model.

Mark

raman_rastogi
Partner - Creator III
Partner - Creator III

In Chart Expression

Sum(B.Salary)+Sum(P.F)

Or

[B.Salary]+[P.F]

In Script

Load

B.Salary,

P.F,

B.Salary+P.F as Total

From DataSource;

Regards

Raman