RE: Bar chart in qlik sense

[indhuh44]

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.

[Kashyap_R]

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'

[indhuh44]

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.