How to get the last value from a product in time

[#1]

Hello,

I am dealing with a problem for some time now and I can't find a solution that might be easy for you.

The problem seems simple but I am still a beginner in QlikView.

The situation is as follows:

I have a dataset with 4 months of data. In this period of time the quantity of products changed.

What I want is to get is the last quantity.

Imagine this, if I am looking for this last 4 months of data and the product 12345678

Month	Product	Qty
1	12345678	10
2	12345678	-5
3	12345678	10
4	12345678	5

I want to get the Qty = 5 for example in a TextBox.

I have tried the firstSortedValue but it is not returning the value I expected.

Please see attached file.

Thanks very much

[#2]

Hello,

Yes that works using the date as a Int like in this example. But in my application, Date is not like that.

The following error shows:

Error: Error in set modifier ad hoc element list: ',' or ')' expected

I've tried this but no luck:

=Sum({<num(Date)={$(=max(num(Date)))}>}#Qty)

The following error shows:

Error: Error in set modifier expression

Thanks

[kkkumar82 · Accepted solution]

Hi,

Are your dates in string format or in date format, if there are in date format

=Sum({<Date={'$(=max(Date))'}>}#Qty)

Thanks

Kiran Kumar

[Saravanan_Desingh]

To get the Top Qty, you can also try like this..

Only({<Month={"=Rank(Month)=1"}>}Qty)

[#5]

Hello,

thanks a lot, that solved my problem.

Cheers