top 10 file no and transaction date based on amount along with name in straight table
Hi all,
I need help in my current assigment where i want to achieve result in a straight table like ....
I need top 10 applicant name based on their amount (disbursement/debt balance) along with file no and Date (on which date this amount was disbursed in this file no). Date field is must in staright table .
Date and file no is must..........
Please find out the qvw doccument attached for your understanding and reference..........
Thanx for your valuable suggestion , Can you send me an example qvw of my doccument with date field in straight table agaist file no or applicant name so that i can go further with this approach.
That would be very heplful for me because i am in a middle of a project to deliver this report .....
Can you guide me in this qvw for date field because i am getting all other field perfect in case of logic and top ten scenarion but when i am adding Fdate (First disbursement Date) against those fiel no and applicant name thats not working ,
For your understanding please see qvw aatched and please reply me with attached doccument because in this scenario i have to show file no and applicant no with their first disbursement date ........
I'm not sure I understand what you did with the document. You removed the top-10 calculation. Here it is again. I've added FDate. You will see row duplication--that is because there are multiple FDates per that customer and debt (maybe an error with your data?). It looks better in a pivot table, but if your data is correct then maybe it would be better to leave FDate out of the table altogether. Up to you.
But Can we set same rank function in staright table too....... because my customer needs this result only in straight table ....or should i send you this qvw again..........
Dushyant, the exact same dimensions/expressions will work in a straight table. It will just not look as nice. Please clarify: do you need FDate to be a single (minimum) value for a debt, or is your data correct and there are actually many FDates per 1 debt?
Luis, it depends on what he needs. If he wants only the minimum date, then he should just make an expression (not dimension): min(FIRST_DISB_DATE). If he wants multiple FDates per debt, then FDate must stay a dimension.
Thanks for such a prompt response vlad,but did you see if i am not making any selection then date appreared is only from mumbai that too many times ,Is this the problem of Date Modeling or sumthing else ????
I'm sorry, I don't understand what you're asking. FDate = minimum date over the dimension shown. Example (no selections): Customer: AJAY; Branch: Delhi; Debt: DEL/0048; FDate = 8/18/1998. You can verify that this is correct with table boxes.
