Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Expression or Script Help

Hi I have some data which is attached. My Financial year is 1st April till 31st March. Now I have to find the Rate of Code Year wise.

For Example - 

Code - 74561 -  Financial Year 2021 - 2022 Rate is 10920.

For 2020 - 2021 We don't have rate So rate will be same 2021 - 2022 Rate is 10920.

But For 2019 - 2020 We have rate, So we have to check max FromDate and ToDate and Rate is 10500 so for 2019 - 2020 - Rate is 10500.

Simillary for Code - 96288

Please find the attached xls for data.

Thanks

0 Replies