Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.