Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gino12433
Contributor
Contributor

Bar chart visualisation

Hello,

I have a question about a visualisation that i am trying to make.

For this visualisation i am using the following query: https://syntheticmass.mitre.org/fhir/Observation?code=55284-4

This query gives back all observations that contain the code 55284-4, wich indicates the observation blood pressure. The blood pressure contains two types of values, the systollic and the diastollic bloodpressure.

The problem that i running into is that qlik sense puts the systollic and dyastollic value in one column, Like this:

qlik vraag bloeddruk.PNG

When i want to present the average value`s of the diastollic and systollic measurements per year, i am not able to.

The only thing that i can is this:

bloeddruk bar chart.PNG

But the this wat i want is that the dimension are the years and the presented values are two measurements one bar with the systollic values and one with only the diastollic values.

Is there someone that could help me with this?

Regards Gino

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Add year as dimension to the bar chart as well.

Or if you want to use two expressions use these:

  • avg({<display_u0={'Systolic Blood Pressure'}>} value)
  • avg({<display_u0={'Diastolic Blood Pressure'}>} value)

talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Add year as dimension to the bar chart as well.

Or if you want to use two expressions use these:

  • avg({<display_u0={'Systolic Blood Pressure'}>} value)
  • avg({<display_u0={'Diastolic Blood Pressure'}>} value)

talk is cheap, supply exceeds demand
nsetty
Partner - Creator II
Partner - Creator II

Are you looking similar to this

1567018.PNG

gino12433
Contributor
Contributor
Author

Hello,

Thank you for looking into my problem.

I used the expressions from gwassenaar‌ and it works perfectly.

goede vorm bar chart.PNG

Regards Gino