Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
To get the Top Qty, you can also try like this..
Only({<Month={"=Rank(Month)=1"}>}Qty)
Hello,
thanks a lot, that solved my problem.
Cheers