simple sum(plan_qty) i cant get

[Anonymous]

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.

[Anil_Babu_Samineni]

Where you are trying this Measure? I meant to say which object is this? Can you check whether "Full Accumulation" option got enabled?

[passionate]

\you Device data in excel is not consistent

eg: DEVICE7 and DEVICE 7

there are spaces

[Anonymous]

Hi Anil,

full accumulation is not enabled.

FYI

[Anonymous]

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))

[sasiparupudi1]

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);

[Anonymous · Accepted solution]

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))