Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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 - Creator III
Partner - Creator III

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))

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