Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmark1990
Contributor III
Contributor III

Display double values in bar-chart

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:

grafiek.png

The data to plot is:

   

DiagnoseIdPatiëntIdDiagnosePatiëntTypeDiagnosePatiëntScore
Addiction001Sub9
Addiction003Sub12
Addiction009Sub6
Addiction010Sub9
Addiction011Sub11
Addiction013Sub10
Addiction015Sub12
Addiction019Sub10
Addiction023Sub11
Addiction024Sub9
Addiction025Sub12
Anxiety002Sub10
Anxiety004Sub10
Anxiety006Sub9
Anxiety007Sub12
Anxiety011Sub11
Anxiety015Sub11
Anxiety016Sub9
Anxiety017Main8
Anxiety020Main11
Anxiety022Sub11
Depression001Main11
Depression002Main8
Depression003Main8
Depression005Main8
Depression006Main10
Depression007Main8
Depression008Main10
Depression009Main14
Depression010Main10
Depression011Main10
Depression012Main9
Depression013Main11
Depression014Main12
Depression015Main11
Depression016Main10
Depression017Sub14
Depression018Main11
Depression019Main8
Depression021Main11
Depression022Main10
Depression023Main10
Depression024Main10
Depression025Main14
Other005Sub13
Other014Sub12
Other018Sub11
Other020Sub11
Other025Sub10
Personality disorder008Sub10
Personality disorder018Sub8
Personality disorder025Sub12
PTSD005Sub8
PTSD012Sub8
PTSD018Sub14
PTSD021Sub10
Somatoform disorder002Sub10
Somatoform disorder004Main15
Somatoform disorder011Sub10
Somatoform disorder022Sub11

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'.

1 Reply
sunny_talwar

Something like this?

Capture.PNG