Create a Graph to show only specific entries from my data

[Glynn1969]

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

[MayilVahanan · Accepted solution]

Hi

Try like below

Dim: Grade

Measure: Count({<[End date] = {'open'}>}Distinct Name)