Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Expression Help in QlikView

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 - 74561 -  Financial Year 2021 - 2022 Rate is 10920012. For 2020 - 2021 We don't have rate So rate will be same 2021 - 2022 Rate is 10920012.

But For 2019 - 2020 We have rate, So we have to check max From and ToDate and Rate is 10500000.

Please find the attached xls for data.

Thanks

Labels (2)
0 Replies