Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there Qlikers!
I am needing again help from my project.
I only wanted to get the sum of plan_qty but for some reason, there is a glitch that I cannot solve.
I have here a sample of the excel file. in pivot i can get the total plan_qty but when I create it in qlikview the expression is giving me different result.
thanks and looking forward to hearing from you.
thank you all for the help.
i did get the formula right for my problem and below is the simple solution.
Sum(Aggr(Sum(DISTINCT {$<Fiscal_Week ={$(=Max(Fiscal_Week))}>} PLAN_QTY),LOTS))
Where you are trying this Measure? I meant to say which object is this? Can you check whether "Full Accumulation" option got enabled?
\you Device data in excel is not consistent
eg: DEVICE7 and DEVICE 7
there are spaces
Hi Anil,
full accumulation is not enabled.
FYI
I was able to get the total count of device correctly using below formula
Count(Aggr(If(Count(device)=1,1,0),lot_id, Fiscal_Week))
i tried to do the same using the qty, but the result is giving me the incorrect data.
sum(Aggr(If(Count(device)=1,1,0),plan_qty, Fiscal_Week))
PFA
T1:
LOAD Fiscal_Week,
focus_group,
lot_id,
plan_qty,
plan_hours,
FCP_CRITERIA,
Replace(DEVICE,' ','') as DEVICE
FROM
(ooxml, embedded labels, table is RAW);
thank you all for the help.
i did get the formula right for my problem and below is the simple solution.
Sum(Aggr(Sum(DISTINCT {$<Fiscal_Week ={$(=Max(Fiscal_Week))}>} PLAN_QTY),LOTS))