Discussion board where members can get started with QlikView.
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
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
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.