Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi
Try like below
Dim: Grade
Measure: Count({<[End date] = {'open'}>}Distinct Name)
Hi
Try like below
Dim: Grade
Measure: Count({<[End date] = {'open'}>}Distinct Name)