0 Replies Latest reply: Aug 15, 2016 3:55 AM by Ram Marthi RSS

    qliksense app development

    Ram Marthi

      Hi,

       

      Can anyone help me with this problem please.

       

      I have a table as below:

      Work Order NoWork Order DatePayment Received DateFiscal YearPayment Value
      A00110/03/201510/03/2015155000
      A00110/03/201515/04/2015163000
      A00210/07/201610/07/2015163000
      A00210/07/201610/06/2016177000
      A00210/07/201611/07/2016175000
      A003-10/05/2016176000
      A003-11/05/2017181000

      Now that I wanted Current Fiscal Year and Carry Over Fiscal Year for each Work Order Received. Wherein Current fiscal year is the fiscal year against the work order date. If work order date is not there then lease payment received date should be taken as a work order date and the fiscal year against that row should be current fiscal year.

       

      Now when I Select a work order (or a list of work orders) I should get current fiscal year, carry over fiscal year and payment received in current year and payment received in carry over fiscal year.

      Output:

      Work Order NoCurrent Fiscal YearCarry Over Fiscal YrCurrent Yr Payment Received ValueCarry Over Yr Payment Recieved
      A001151650003000
      A0021617300012000
      A003171860001000