The below task need to be worked on qlik sense
Data:
| id | Date | Description | Status |
| Id1 | 8/2/2019 | Details are present | Failed |
| Id1 | 8/2/2019 | Number of records not displayed | Passed |
| Id1 | 8/2/2019 | Document submitted | Passed |
| Id2 | 7/3/2019 | List is not there | Failed |
| Id3 | 6/3/2019 | values present | Passed |
I have the data like above and the output of the above data should like below:
sheet1:
| id | Date |
| Id1 | 8/2/2019 |
| Id2 | 7/3/2019 |
| Id3 | 6/3/2019 |
When clicking on ID1 the cases belong to Id1 should displayed on another sheet
| Description | Status |
| Details are present | Failed |
| Number of records not displayed | Passed |
| Document submitted | Passed |
