Bar chart visualisation

[Anonymous]

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:

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:

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

[Gysbert_Wassenaar · Accepted solution]

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)

[nsetty]

Are you looking similar to this

[Anonymous]

Hello,

Thank you for looking into my problem.

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

Regards Gino