Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner
Partner

Get the last one in stock

Hi Exper

I have a stock values and i want to get the last value of stock, for every date,Prod and Place

i have a lot of values for each date, product and place, and i want to show only the last one(for this combination)

i want to create a table with this information

attached the excel

thanks a lot

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

Hi,

like attached?

=FirstSortedValue(Date,-RowNo)

Capture.JPG

View solution in original post

4 Replies
sunny_talwar

May be this

Sum(Aggr(If(Date + Time = Max(TOTAL <Prod, Place, Date> Aggr(Date + Time, Prod, Place, Date, Time)), Sum(Stock)), Prod, Place, Date, Time))

devarasu07
Master II
Master II

Hi,

like attached?

=FirstSortedValue(Date,-RowNo)

Capture.JPG

View solution in original post

effinty2112
Master
Master

Hi Fernando,

Maybe:

Date Prod Place Aggr(if(Rank(Time)= 1, Stock),Date,Prod,Place,Time)
16/05/20171178618193485
30/05/20171178618193485

Cheers

Andrew

antoniotiman
Master III
Master III

Hi Fernando,

maybe this

Note : In Script LOAD

...,Time(Time) as Time,...

Regards,

Antonio