Discussion Board for collaboration on QlikView Scripting.
Another question from me again .
I have a table with Data:
Buyer number - amount - Last Day to pay(Date format)
One buyer can have more then one Days to pay. Is there a possibilty to write a script: Give me for every buyer only the oldest Date?
I can import all the data into QV(but its a huge file), but i would like if its possible to import only the oldest Date(with buyer number and amount).
how does the formula/scrpit looks like?
min(LastDayToPay) as Date
Group by BuyerNumber, Amount;
The previous script will give the oldest date ro pay a specific amount. Eg customer A, oldest to pat $150, customer A oldest date to pay $200 etc. Is that the requirement?
I understood the question to mean the oldest date by customer, and the amount payable on that date. If that is so, then
min(LastDayToPay) as LastDate
Group by BuyerNumber;
LastDayToPay as LastDate
should do the trick
Now that I re-read the post, Jonathan is right. Thanks.
In fact the second load would be better as
Sum(Amount) As Amount
Group By BuyerNumber, LastDayToPay;