Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Showing future payments (By interval)

Hi,

Im using a table from  an oracle database. This is a part of that table:

PERIODPAYMENTSTARTDATEPERIODMONTHENDDATENEXTPAYDATELASTPAYDATEAMOUNT
Subsidie 1e kw. 2013 1-1-2009 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:00124
Stimuleringssubsidie afgewezen voor 20111-1-2003 0:00231-12-2010 0:001-1-2011 0:001-10-2011 0:001065
Subsidie gestopt 1-1-2009 0:00131-12-2010 0:001-1-2011 0:001-12-2010 0:001081
Subsidie 4e kw.2011 1-1-2009 0:00331-12-2011 0:001-1-2012 0:001-10-2011 0:00499
Fractievergoeding 1e kw.20131-4-2006 0:00331-3-2014 0:001-4-2013 0:001-1-2013 0:00104,94
Subs.aangepast sporten 1e kw. 20131-1-2003 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:001392
subsidie 1e kw. 2013 1-4-2011 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:00463
subsidie 1e kw. 201331-3-2010 0:00331-12-2013 0:001-4-2013 0:001-1-2013 0:004938

I want to show the sum of the amount for each value from the column PERIODPAYMENT by the date, but als the payments in the future. The trick is the PERIODMONTH field, which shows the interval of the payment.

So for example when i click on the year 2013 and click on the value 'subsidie 1e kw. 2013' i see sum of the amount by the following months: Jan, Mar, Jun etc.

Does someone know how i can make this work?