Sumif in Qlikview

[venkatbza]

Hi folks,

Please help me to convert sumif condition from excel into qlikview.

I have done with for loop  also values are matching but creating performance issue, please suggest any other way is there.

Below is the condition 

=SUMIF(B2:B25,C2)

Data:

Value	Reference value
10.00	>=11
20.00	>=21
30.00	>=35
40.00	>=41
50.00	>=55
60.00	>=60

Required Output:

Output

200

180

150

110

60

60

Excel output

[MindaugasBacius]

I would make it simple with nested IF statements. In backend you need to create new field like:

If(Value >= 60, 60, If(Value >= 55, 60, If(Value >= 41, 110, If(Value >= 35, 150, If(Value >= 21, 180, If(Value >= 11, 200, 0)))))) as OutPut

[venkatbza]

Hi,

Thanks for reply, this is not what I am expecting , I have a data fields 'Value' and 'Reference value' and I dont have any output field I need to calculate  output field based on these two fields.