Resident load failing - why?

[#1]

Hi All

I have the following code to caculate the stdev based on a count of distinct Epinums:

Stdev1a:
LOAD cResItemName,
  Sum(TotalCost) as sumTotal,
  count(distinct Epinum) as countEpinum
FROM
datasources\QlikviewReport1.qvd
(qvd)
GROUP BY cResItemName;

Stdev1:
LOAD cResItemName,
  stdev(sumTotal/countEpinum) as zz_Chk_StDev_Epinum
RESIDENT Stdev1a;

DROP TABLE Stdev1a;

But the script fails with this cryptic message (at least to me!):

zz_Chk_StDev_Epinum,

Stdev1:

LOAD cResItemName,

  stdev(sumTotal/countEpinum) as zz_Chk_StDev_Epinum

RESIDENT Stdev1a

Please could anyone point out what's wrong with my script?

Thanks

Dom

[stephencredmond · Accepted solution]

Hi Dom,

When you calculate your Stdev, this is also a grouping so you are going to need "Group By cResItemName" after the "RESIDENT Stdev1a".

Regards,

Stephen

[#3]

That's great, thanks Stephen.