Discussion Board for collaboration related to QlikView App Development.
I would like to count no.of Ecode where Demand Quantity is greater than same Ecode Demand Quantity.
let me explain above data with the formula.
Demand 1350 is the largest values so the count of Ecode should be 1.
Demand 78 is less than 1350,700 So the count is 3,
Demand 700 is less that 1350 so the count is 2 ,
Finally 0 is less than all the others right so the count is 4.
Please let me know how to achieve this Qlikview, In Excel the formula is =COUNTIFS(B:B,B32,I:I,">"&I32)+1
I need to formula in Load Script.
Thanks & Regards,
May be this
If(Ecode = Previous(Ecode), RangeSum(Peek('Output'), 1), 1) as Output
Order By Ecode, Demand desc;
View solution in original post
Autonumber(recno()), Ecode) as Output
From ... Table
Order by Demand Desc;
I have got the solution,
If( [E Code] = Previous([E Code]),
if ([Demand Qty for Sep] = Previous([Demand Qty for Sep]),
Peek('Forecast_Rank'),RangeSum(Peek('Forecast_Rank'), 1) + Peek('E_Code_Commulative')), 1)
If( [E Code] = Previous([E Code]) and [Demand Qty for Sep] = Previous([Demand Qty for Sep]),
Peek('E_Code_Commulative') + 1 , 0) as E_Code_Commulative