Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Creating amortization plan in a chart


I have   table With multiple loans, and each of them has a value called [End Balance USD].

I am trying to put these data in a chart With a Dimension Drilldown that goes from Year-YearQuarter-YearMonth-YearWeek-Date.

I do not know how to Write the correct set analysis to get the correct loan Balance in these periods, I end up getting the sum of all periods if I Select any lower granularity than Date.

Anyone that know how to Write an Expression that will pick the value from either the first date or last date in period?


Br Espen

Labels (3)
0 Replies