Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
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.


Labels (2)
0 Replies