Sum of selective number of fields as a calculated field

[Lokesh_5045]

Hi All,

I am new to Qlik Sense. I have a data like below. I have to add number of selective fields as a calculated field. Please help me to write a script in backend.

	Field1	Field2	Field3	Field4	fields to be added	Calculated field 1
A	3	6	6	7	2	9
B	2	6	7	4	4	19
C	1	8	2	5	3	11
D	7	6	2	6	1	7
E	7	1	9	10	4	27

Example A: Fields to be added - 2
Field1 (3) + Field2 (6) = 9

Example C: Fields to be added - 3
Field1 (1) + Field2 (8) + Field3 (2) = 11

I need this logic in backend script.

[Mr_Pearl]

Did you try below,

Field1 + Field2 as Total_2_field,

Field1 + Field2 + Field 3 as Total_3_field

From...

[Lokesh_5045]

That would give me Total_1_field to Total_4_field (4 fields). It is not my calculated field.
My calculated field is based on numbers of fields to be added.

[Lokesh_5045]

I guess, you have given me a hint. If "Fields to be added = 3", Then Total_3_field as my calculated field.

if(Field to be added = 1, Total_1_Field,
Field to be added = 2, Total_2_Field,
Field to be added = 3, Total_3_Field .....))) as Calculated_field

Let me try this approach.
In my case, there are month fields (total 12). I need to add values under month fields. 

[Lokesh_5045]

@Mr_Pearl Thank you for your advice. It worked. But in the above case, I have given an example of data 4 fields and one calculated field. To get 1 calculated field, we have created 4 total fields.

In my case, there are 12 month fields and each month field is having its own calculated field. In such case, we have to create 144 fields and this may not be a good idea.

Material	Jan	Feb	Mar	Apr	Months to be added	Calc_Jan	Calc_Feb	Calc_Mar	Calc_Apr
A	3	4	7	4	4	(Jan:Apr) 18	(Feb:May) NA (insufficient_data)	(Mar:Jun) NA (insufficient_data)	(Apr:Jul) NA (insufficient_data)
B	3	2	4	5	2	(Jan:Feb) 5	(Feb:Mar) 6	(Mar:Apr) 9	(Apr:May) NA (insufficient_data)

[rwunderlich · Accepted solution]

I think you could do it with RangeSum() and If(). 

RangeSum(
If([Fields to be added] >= 1,  Field1)
,If([Fields to be added] >= 2,  Field2)
,If([Fields to be added] >= 3,  Field3)
,If([Fields to be added] >= 4,  Field4)
) as [Calculated Field]

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Lokesh_5045]

@rwunderlich That worked like a beauty. I was trying the combination of Rangesum() and for loop, but didn't get answer. I didn't get idea of combination of RangeSum() and If(). Thank you so much for making it very simple.