Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten
Creator II
Creator II

Filter dimension in barchart with 2 measures

See attachment. I have a barchart with two measures. The graph should be filtered by showing the measures of only 1 systemtype.

Although creating a dimension with the expression:  if ((product_configuration = ‘systemtype1’), product_configuration) doesn’t work

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Add below set analysis in bold to both your measures

Sum( {<product_configuration={'systemtype1'}>} CMHours)

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Add below set analysis in bold to both your measures

Sum( {<product_configuration={'systemtype1'}>} CMHours)

Kirsten
Creator II
Creator II
Author

It works thanks. The only thing is I added a dimension in the expression to change the color which I had to remove, to be able to add the expression. 

The attachment shows where I added the expression