Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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
Highlighted
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.