Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
GaryChin
Contributor III
Contributor III

How to filter data in a bar chart?

Dear All,

I am a new user for the Qlik Sense.

The data have three fields : measure_time, measure_point, measure_value. Please refer to the attachment.

Data2.PNG

The measure contain 3 parameter Temp, CO2 & HR. My problem is how to show these 3 parameter in same bar chart individual.

Bar Chart.PNGExpression.PNG

Or how to filter these 3 parameter in 3 individual field.

 

Regards

Gary

 

 

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

Avg({<measure_point={'CO2'}>}measure_value)

Change to other parameter as required.

Thanks and regards,

Arthur Fong

View solution in original post

5 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Do you mean Stacked Bar Chart?

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Example of a stacked bar chart:

MC.PNG

In chart properties > Appearance > Presentation > Stacked.

GaryChin
Contributor III
Contributor III
Author

Thank you for your reply.

I did not mean a  stacked chart. Maybe it can show one parameter in one chart. I selected aggregation - avg

aggregation.PNG

3bar Chart2.png

However the measure value for  3 chart are same. Because I don't know how to separate the Temp, CO2 and HR which are in same field "measure_ point"

Data3.png

Regards

Gary

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

Avg({<measure_point={'CO2'}>}measure_value)

Change to other parameter as required.

Thanks and regards,

Arthur Fong

GaryChin
Contributor III
Contributor III
Author

Thanks Arthur! It work.