Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Statement of Account

NEED HELP EXPERTS. I have years and corresponding payment, example 2005 should I start the payment up to the present. Annual payment is 3000

YearAmount
20053000
20063000
20072500

As you notice I still have balance in 2007, Now I want to display records in the statement of account or balances.

from unpaid year up to present... IT SHOULD DISPLAY LIKE BELOW...

YearAmount
2007500
20083000
20093000

HOW TO DO THIS?

Thanks,

Best regards,

Bill

2 Replies
rohit214
Contributor III

Statement of Account

hey bill,

why dont you make another column for showing the remaining Amount

thanks &Best Regards

rohit

Not applicable

Statement of Account

Thanks Rohit,

I already solved this problem, anyways thanks for your help.

Community Browser