topic Re: Sumif in Qlikview in QlikView

Sumif in Qlikview

venkatbza — Sat, 16 Nov 2024 02:47:00 GMT

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

Excel output

Re: Sumif in Qlikview

MindaugasBacius — Fri, 09 Aug 2019 06:03:59 GMT

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

Re: Sumif in Qlikview

venkatbza — Fri, 09 Aug 2019 06:23:19 GMT

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.