Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rammarthi
New Contributor III

qliksense app development

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
Tags (1)
Community Browser