Sum of AMount using Max version Logic in Qlikview - Expression
I have to create the following logic in the expression not in the script in a straight / Pivot table.
1. Retrieve all the rows where CREATION_DATE is less than the User Selected date AS_DATED. (Not shown in the sample data). AS_DATED is a filter in the sheet from where user can select a date. 2. Then for each LNUMBER, Select the distinct TERM IDs available. 3. For each distinct TERM_IDs then select the MAX Version. There may be multiple rows with max version. 4. Then SUM the amount.
In the example below the output should be the last 3 lines. Sum Of Amount should be (16.5+ (-74.93) + .54)= - 57.89