Discussion Board for collaboration on QlikView Scripting.
Attached herewith is my sample QV Buying Model. I have attached my data source which is in excel.
In my chart table, i have a stock required column. I want to create a TOTAL STOCK REQUIRED column per item ( ie i want to create the column highlighted in yellow).
How do I do this?
Please note in the table below, I have hidden other columns , so that the table looks legible.
TOTAL Stock Required
Go to Solution.
Use below expression to get Total Stock Required
sum(TOTAL<[Item Code]> aggr(rangemax(0,$(vAvgLast6Months)*$(No of Months)-sum([Quantity on Hand])),Branch,[Item Code]))
You need to use Total Function with grouping of Item Code some thing like below
NUM(sum(TOTAL <[Item Code]> aggr(rangemax(0,$(vAvgLast6Months)*$(No of Months)-sum([Quantity on Hand])),Branch,[Item Code])),'##0')
Than you Max and Manish. Both your formulae worked.