Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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