Problems in Load statement

Stefan_Weber — Thu, 14 Feb 2019 12:54:51 GMT

Hello Qlikview Community,

I am trying to load data from different sources into my Qlikview File: in the following I try to describe what I am doing:

1) Loading Data from an SQL Database in a Qlikview Table (Data_Raw)

2) With this data I try to do calculations

Data_SegmentData:
LOAD
AssetKey,
ProductionSegmentID,
PVKey,
timestamp(min(left(ProductionStartTime,19))) as ProductionSegmentStart,
min(left(ProductionStartTime,19)) as ProductionSegmentStartNumber,
timestamp(max(left(ProductionEndTime,19))) as ProductionSegmentEnd,
Interval(max(left(ProductionEndTime,19)) - min(left(ProductionStartTime,19)), 'hh:mm') as ProductionSegmentDuration,
if(Sum(if(AEProductionCategoryKey = 'OAE Prod',ProductionQty))>0,Interval(max(left(ProductionEndTime,19)) - min(left(ProductionStartTime,19)), 'hh:mm')) as ProductionSegmentDurationProd,
if(Sum(if(AEProductionCategoryKey = 'OAE Prod',ProductionQty))>0,round(Sum(if(AEProductionCategoryKey = 'OAE Prod',ProductionQty)),0.01)) as ProductionSegmentQuantity,
if(Sum(if(AEProductionCategoryKey = 'OAE Prod',ProductionQty))>0,round(Sum(if(AEProductionCategoryKey = 'OAE Prod',ProductionQty)),0.01) /(Interval(max(left(ProductionEndTime,19)) - min(left(ProductionStartTime,19)), 'hh:mm')*24)) as ProductionSegmentmmax

resident Data_Raw group by ProductionSegmentID;

this statement is not working, because the AssetKey and PVKey are not part of the group by clause (at least that is what I think)

When trying to join load this information, Qlikview is generating Syn Tables (AssetKey/PVKey/ProductionsegmentID) which is not what I want.

Is there a way to get the information AssetKey and PVKey in the above mentioned table ?

Maybe by loading a combination of AssetKey_PVKey_ProductionSegmentID in each Table ?

Or is there an alternative ?

Thanks

Stefan

Re: Problems in Load statement

Stefan_Weber — Thu, 14 Feb 2019 14:26:28 GMT

Hello community,

since AssetKey and PVKey just occur once per ProductionSegmentID I could include them in the group by clause.

Sometimes the simplest solution is the right one.

Thanks for taking the time and looking at this topic.

Regards

Stefan

topic Problems in Load statement in QlikView

Problems in Load statement

Re: Problems in Load statement