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

How to get 2 measure values in a single bar in qlik sense?

Hi expects,

I have to show  count(column1)   and  percentage (column1)   in single bar .Capture12.PNG

as you can see  it should be on same bar and tool tip  also fine .

i tried count in measure and percentage in color and i am getting tool tip  of both but i  am  having same related fields charts in sheets so through out i should get same field color .so this method is not much useful .so is  there any method to solve this .

thanks,

krishna

1 Solution

Accepted Solutions
OmarBenSalem

You can't show them on the bar, but you can for example , show the percentage besides the dimension, and the value on the bar:

as dimension =

YourDim&' : '&  num(aggr((sum(measure) / sum(total {<YourDim>} measure)),YourDim),'# ##0,00%')

result:

Capture.PNG

View solution in original post

1 Reply
OmarBenSalem

You can't show them on the bar, but you can for example , show the percentage besides the dimension, and the value on the bar:

as dimension =

YourDim&' : '&  num(aggr((sum(measure) / sum(total {<YourDim>} measure)),YourDim),'# ##0,00%')

result:

Capture.PNG