Is it possible to show % and no in bar garph

[savithri_n_s]

Hi Team,

Attached the qvw file.

In dashboard 8  % competitive Rate wos bar chart. Is it possible to show chart like this?

In the first bar in the qlik view chart i want  32 to be subset of 539 in the graph shown and also is it possible to display percentage as shown

formula to calculate  % Competitive Rate Contractors is as below

alt((Count({<[Data Source] = {'CX Managed','Cx Managed'}, [Assignment State]= {'Effective','Effective-OnBoard'},[Comp vs Non-Comp]={'Competitive'}>}
If([Assignment Start date] >=MonthStart(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')) and [Assignment Start date] <= MonthEnd(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')), [Data Source]))/
Count({<[Data Source] = {'CX Managed','Cx Managed'}, [Assignment State]= {'Effective','Effective-OnBoard'},[Comp vs Non-Comp]={'Competitive','Not Competitive'}>}
If([Assignment Start date] >=MonthStart(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')) and [Assignment Start date] <= MonthEnd(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')), [Data Source]))),0)

Regards,

Savithri

[Lisa_P]

Hi Savithri,

I have converted your chart to a stacked bar to get a similar view, but not showing %.

Or a mekko that is more interested in the breakdown ..

But your values are not in % format.

Regards,

Lisa

[jyothish8807]

Hi Savithri,

Check this sample, hope this help. You can modify your expressions to achieve your requirement.

Br,

KC

[pooja_prabhu_n]

Hi Savithri,

Is it fine if you display the % on axes instead of top of the bar?

Thanks,

Pooja

[savithri_n_s]

Thank you all for your help:)