topic Re: simple sum(plan_qty) i cant get in QlikView

simple sum(plan_qty) i cant get

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: simple sum(plan_qty) i cant get

Anil_Babu_Samineni — Sun, 15 Apr 2018 05:59:03 GMT

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

Re: simple sum(plan_qty) i cant get

passionate — Sun, 15 Apr 2018 06:59:32 GMT

\you Device data in excel is not consistent

eg: DEVICE7 and DEVICE 7

there are spaces

Re: simple sum(plan_qty) i cant get

Anonymous — Sun, 15 Apr 2018 08:56:11 GMT

Hi Anil,

full accumulation is not enabled.

FYI

Re: simple sum(plan_qty) i cant get

Anonymous — Sun, 15 Apr 2018 08:59:25 GMT

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

Re: simple sum(plan_qty) i cant get

sasiparupudi1 — Sun, 15 Apr 2018 17:13:47 GMT

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

Re: simple sum(plan_qty) i cant get

Anonymous — Sat, 28 Apr 2018 03:37:29 GMT

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