topic RE: Bar chart in qlik sense in App Development

RE: Bar chart in qlik sense

indhuh44 — Sat, 16 Nov 2024 04:18:49 GMT

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.

Re: RE: Bar chart in qlik sense

Kashyap_R — Tue, 22 Oct 2019 06:06:47 GMT

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'

Re: Bar chart in qlik sense

indhuh44 — Tue, 22 Oct 2019 14:40:40 GMT

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.