Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Need Values and Percentage Share in Stacked bar Chart

Hi All,

I have a stacked bar chart on Category and Market.

I need Values as well as Percentage share on the bar chart.

Please help me to do so.

Thanks,

Sarif

1 Solution

Accepted Solutions
sunny_talwar

Something like this?

Capture.PNG

The only issue is that smaller bars won't really show any value because of the space constraints. Expression used

=Dual(Num(Sum(Quantity), '#,###.') & Chr(10) & Num(Sum(Quantity)/Sum(TOTAL <Market> Quantity), '##.##%'), Sum(Quantity))

View solution in original post

14 Replies
sunny_talwar

One of these two?

Capture.PNG

For one, use this expression

=Sum(Quantity)/Sum(TOTAL <Market> Quantity)

For two, check relative on the expression tab

mhmmd_srf
Creator II
Creator II
Author

I need combination of Base and 1.

Chart should show you the vale and Percentage.

qv_testing
Specialist II
Specialist II

PFA,

%age:

sum(Quantity)/SUm(TOTAL Quantity)

for 100% Staked bar:

sum(Quantity)/SUm(TOTAL <Market>  Quantity)

sunny_talwar

Can you elaborate? What is Base?

fabdulazeez
Partner
Partner

than you will have to append both i suppose

mhmmd_srf
Creator II
Creator II
Author

For below example:

Lets say for Asia Pacific.

I need to show values on data point Technology = 10480 along with this I want to show 21.56 % i.e. 10480/(10480 + 27948 + 10169)

So Sum and Percent both I need to show in Values on Data Point.

sunny_talwar

Something like this?

Capture.PNG

The only issue is that smaller bars won't really show any value because of the space constraints. Expression used

=Dual(Num(Sum(Quantity), '#,###.') & Chr(10) & Num(Sum(Quantity)/Sum(TOTAL <Market> Quantity), '##.##%'), Sum(Quantity))

View solution in original post

mhmmd_srf
Creator II
Creator II
Author

Thanks Sunny... this is I want.

pandiarajan
Creator
Creator

Hi Sunny,

will it work in Qliksense? I want to apply the same logic in Qliksense. I have created one cyclic group and I applied same logic which I have applied in Qlikview but not working in Qliksense. Is there any other way to achieve this in Qliksens?

Thanks & Regards,

Pandiarajan.R