Hello - wondering is any one can answer what i assume is a basic question - i'm new to qlik sense so just at the bottom of my learning curve.
I have a set of data (small size used here for my example), and i want to show a graph to show the numbers of people by Grade who still have an "open" end date - so from my example below i would have "Grade" as my X-AXIS and a bar chart with a value of 1 for EO (Ben) and 2 for AO (Carole and Fred) on my Y-Axis - hope that makes sense.
| Name |
Grade |
Start Data |
End date |
| AL |
AO |
01/05/2023 |
27/05/2021 |
| AL |
AO |
26/07/2022 |
29/12/2022 |
| ben |
EO |
14/02/2021 |
21/10/2022 |
| ben |
EO |
29/12/2023 |
open |
| carole |
AO |
15/09/2022 |
open |
| dan |
AO |
17/02/2023 |
20/06/2023 |
| eve |
EO |
14/08/2022 |
21/01/2023 |
| fred |
AO |
06/01/2021 |
18/09/2021 |
| fred |
AO |
16/12/2022 |
open |
