Getting data between the two date columns in set analysis
Hello Community,
I am new to Qlikview. I have a small requirement that I have a table in excel with table columns as Emp ID, Emp Name, Designation, Salary, Join date and End Date. Based on the last 2 date columns we need to display the Employee name, Designation and salary. That means when we select the Join Date and End Date, we need to display the employee information between these two dates using set analysis. Please Help me. It's like an "Asof Designation" concept. The below data is displaying dummy information.
