Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pacoli2013
Contributor

Data for my question about Max(LoadingDate)

Hello,

I cannot add DataFiles to my first question about Max(LaadingDate)

So here is some data and a script

Regards

Court

2 Replies

Re: Data for my question about Max(LoadingDate)

You were having LoadingDate in your Group By statement.... Try this

LOAD

  Company,

      DataLevel,

      Max(LoadingDate) as LoadingDate,

      SalesOrderNumber,

      Description,

      SalesOrderStatusCode,

      SalesOrderTypeCode,

      LatestConfirmationDate,

      DWHReportingCompCurrencyExchangeRateToCompCurrency

FROM [TrnDat_SalesOrderHdr.qvd] (qvd)

  Group By Company, DataLevel, SalesOrderNumber, Description, SalesOrderStatusCode,

  SalesOrderTypeCode, LatestConfirmationDate, DWHReportingCompCurrencyExchangeRateToCompCurrency;

pacoli2013
Contributor

Re: Data for my question about Max(LoadingDate)

Thanks Sunny,

So simply, why did't I figure it out by myself.

Perhaps I'm working too long at the same Document and become blind for such little things.

Regards

Court

Community Browser