Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishna789
Contributor

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
Highlighted
omarbensalem
Esteemed Contributor

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

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

1 Reply
Highlighted
omarbensalem
Esteemed Contributor

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

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