Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Creating amortization plan in a chart

Hi

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