Display double values in bar-chart

qlikmark1990 — Thu, 26 Oct 2017 14:09:37 GMT

I plotted data from patients those have a diagnosis and each diagnosis has a score. There are 25 patients those can have 1 main diagnosis and 1 or more sub diagnoses. At least one main diagnosis and 1 sub diagnosis is obligatory. There are 7 different diagnoses in this dataset and each diagnosis has a certain score per patient. I want to make a bar chart that has the 7 different diagnoses and all of the individual scores plotted. The problem that I have is that double scores aren't plotted, only distinct values are shown in this graph. The graph that I have currently is:

The data to plot is:

DiagnoseId	PatiëntId	DiagnosePatiëntType	DiagnosePatiëntScore
Addiction	001	Sub	9
Addiction	003	Sub	12
Addiction	009	Sub	6
Addiction	010	Sub	9
Addiction	011	Sub	11
Addiction	013	Sub	10
Addiction	015	Sub	12
Addiction	019	Sub	10
Addiction	023	Sub	11
Addiction	024	Sub	9
Addiction	025	Sub	12
Anxiety	002	Sub	10
Anxiety	004	Sub	10
Anxiety	006	Sub	9
Anxiety	007	Sub	12
Anxiety	011	Sub	11
Anxiety	015	Sub	11
Anxiety	016	Sub	9
Anxiety	017	Main	8
Anxiety	020	Main	11
Anxiety	022	Sub	11
Depression	001	Main	11
Depression	002	Main	8
Depression	003	Main	8
Depression	005	Main	8
Depression	006	Main	10
Depression	007	Main	8
Depression	008	Main	10
Depression	009	Main	14
Depression	010	Main	10
Depression	011	Main	10
Depression	012	Main	9
Depression	013	Main	11
Depression	014	Main	12
Depression	015	Main	11
Depression	016	Main	10
Depression	017	Sub	14
Depression	018	Main	11
Depression	019	Main	8
Depression	021	Main	11
Depression	022	Main	10
Depression	023	Main	10
Depression	024	Main	10
Depression	025	Main	14
Other	005	Sub	13
Other	014	Sub	12
Other	018	Sub	11
Other	020	Sub	11
Other	025	Sub	10
Personality disorder	008	Sub	10
Personality disorder	018	Sub	8
Personality disorder	025	Sub	12
PTSD	005	Sub	8
PTSD	012	Sub	8
PTSD	018	Sub	14
PTSD	021	Sub	10
Somatoform disorder	002	Sub	10
Somatoform disorder	004	Main	15
Somatoform disorder	011	Sub	10
Somatoform disorder	022	Sub	11

As example: 'Addiction' is diagnosed for 11 patients so the bar chart needs to contain 11 bars for addiction. However only 5 bars are shown because there are 5 distinct values for 'Addiction'.

Re: Display double values in bar-chart

sunny_talwar — Tue, 07 Nov 2017 12:48:45 GMT

Something like this?

topic Display double values in bar-chart in QlikView

Display double values in bar-chart

Re: Display double values in bar-chart