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
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
thanks for your reply. That works in fact, but I am now struggling with the date.
Because in my application the months are not a numeric like that in this example.
I have changed a little bit the example.qvw file. If you could see this issue in this way I would appreciate very much
It works if you want just Quantity value from maximum month. If you need product wise Qty from latest month then use same expression in straight table with Product as dimension. See this sample created from your data.