Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

RE: Bar chart in qlik sense

Hi , my question i have bar graph created for 2 measures Actual and Target  based on the business dimension.

And they want to show the values on the bar graphs. But the issue is  they want to show the sum of actual's value and in the bracket they want to show the percentage value compared to target. Please find attachment for the picture.

Is this scenario possible in Bar graph. Green color  is target data and black is Actual data.

 Target  value 223.19

Actual  value  232.04 (99.5% of Target).

i am able to get the red color value but

i want the actual value as  232.04 (99.5% of Target) shown in the attachment.

please provide the suggestions if this scenario is possible in Bar graph or not?

Thanks,

Bindhu.

 

 
 
 
Labels (1)
2 Replies
Highlighted
Partner
Partner

Re: RE: Bar chart in qlik sense

Hi 

Use this expression in dimension and replace with your dimensions and measure this will give output as shown in  the attached image.

=[DimensionName]&' : '& aggr(num((Sum([Target])-1000)/Sum([Value]),'##.00%'),[DimesnionName]) & 'of Target'

Highlighted
New Contributor

Re: Bar chart in qlik sense

Hi Kashyap,

Thanks for the response. But i need it for one of the measure to show not on the Dimension.

But will try to work around based on the logic you provided.

 

Thanks,

Bindhu.