Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

Peek orders from the last Year

Hi,

I'm trying to peek orders from the last year but it doesn't work.

LOAD

     [Order ID],

  Max(Year([Order Date])) As MaxOrderYearByOrder

FROM [..\Qvd\FactOrders_6_Import.Qvd] (qvd)

Group By [Order ID];

Someone can explain me why ?

*It must be in the ETL process

Thank.

2 Replies
Highlighted
praveenavelagap
Contributor III

Re: Peek orders from the last Year

Above code gives you most recent order of evrey order id.

If you are pointing to last year then it has to be in where year(OrderDate)=(Year(today())-1)

Highlighted
Not applicable

Re: Peek orders from the last Year

Hi Velagapudi,

This is not what I mean.

Thx.