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: 
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