https://community.qlik.com/t5/QlikView/Expression-Help-in-QlikView/m-p/1814046#M1212821 <P>Hi, I have this data. Now I have to fetch the data for current year Rate, Previous Year Rate by emp code. Like for Emp Code -&nbsp;74561 -&nbsp; Financial Year 2021 - 2022 Rate is&nbsp;10920012. For 2020 - 2021 We don't have rate So rate will be same 2021 - 2022 Rate is&nbsp;10920012.</P><P>But For 2019 - 2020 We have rate, So we have to check max From and ToDate and Rate is&nbsp;10500000.</P><P>Please find the attached xls for data.</P><P>Thanks</P> Thu, 10 Jun 2021 04:48:37 GMT sona_sa 2021-06-10T04:48:37Z https://community.qlik.com/t5/QlikView/Expression-Help-in-QlikView/m-p/1814046#M1212821 <P>Hi, I have this data. Now I have to fetch the data for current year Rate, Previous Year Rate by emp code. Like for Emp Code -&nbsp;74561 -&nbsp; Financial Year 2021 - 2022 Rate is&nbsp;10920012. For 2020 - 2021 We don't have rate So rate will be same 2021 - 2022 Rate is&nbsp;10920012.</P><P>But For 2019 - 2020 We have rate, So we have to check max From and ToDate and Rate is&nbsp;10500000.</P><P>Please find the attached xls for data.</P><P>Thanks</P> Thu, 10 Jun 2021 04:48:37 GMT https://community.qlik.com/t5/QlikView/Expression-Help-in-QlikView/m-p/1814046#M1212821 sona_sa 2021-06-10T04:48:37Z