Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Shu
Contributor II
Contributor II

One measure independent from the dimension in a combo chart?

Hello, 

I have a combo chart. There is one measure that I'd like to be dependent on the dimension, and another measure that I'd like to be independent of the dimension, i.e. not tied to the dimension. What I'm trying to accomplish is to have a straight line that shows a fixed percentage (for example 87%). Below is the expression that shows a percentage that I would like to be independent from the dimension:

Count({1} if([field1], [field2]))
/
Count({1} [field2])

 

Any help is greatly appreciated. 

 

Thanks,

Shu

1 Reply
Shu
Contributor II
Contributor II
Author

I had the wrong approach to this problem. What I did not realize I needed was a reference line in a bar chart. If anyone encountered a similar issue, a reference line is located in Add-onsReference Lines. Then you can add your expression or value as needed.