Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Sumif in Qlikview

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:

ValueReference 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 outputExcel output

 

2 Replies
Specialist III
Specialist III

Re: Sumif in Qlikview

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

 

Highlighted
Contributor III
Contributor III

Re: Sumif in Qlikview

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.