Adding field in Qlikview

[Reddy]

How can we add 2 fields in Qlikview and the 3rd field should be the sum of first 2 fields

Example 

Sales 2019,sales2020

10,20

20,30

40,50

I need a table box with the fields 

Sales 2019,sales 2020,total sales 

10,20,30

[MayilVahanan]

Hi Reddy

these are dimensions - Sales 2019,sales 2020

Measures: Sum(Sales 2019+ sales 2020) 

[Vegar]

If you want to have it in a listbox then you would need to create the sum field in your load script. Like this:

LOAD

[Sales 2019],

[sales 2020],

[Sales 2019]+ [sales 2020] as [Total sales]

FROM Source;

It is also possible to get these value in the front end without script changed. You need to change object Type from table box to straight table.

Add [Sales 2019],[sales 2020] as dimensions and calculate [total sales] as sum ([Sales 2019]+[sales 2020])