Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomovangel
Partner
Partner

Stacked bar chart double values

    Hello guys, I have been wondering, Is it possible to show data points in stacked bar chart like in the picture?

Expected Bar Chart Value.png

I am attaching the qliksense file as well.  I have thought that this is not possible, but as I see in this picture it is?

Anybody know how to do it?

     -Greetings

     Acho

13 Replies
OmarBenSalem
Partner
Partner

or u keep using the extension (with the same dimensions, measure)

and u'll see the percentage when u hover over a dimension:

Capture.PNG

insiyah
Contributor
Contributor

Hi @tomovangel,

Any chance you came across a way to be able to create a stacked bar chart with percentages and values as shown on your screenshot (below)? Need to do the same if possible in Qlik so will appreciate any tips you may have to share. Interestingly enough, it appears it may be possible in Tableau (https://community.tableau.com/thread/244988)

orlando
Partner
Partner

Hi

one solution would be to display both values in the expression by using the dual-function e.g.:

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

This works fine with the bar & area chart object from the qlik visualization bundle but not with the regular bar chart-object (Qlik Sense  April 2020).

jonathandienst

Define the measure something like this:

Dual(
	Num(Sum(value1), '0') & chr(10) & '(' & Num(Sum(value1) / Sum(total value1), '0%') & '),
	Sum(value1)
)

This means the value will display the amount (Sum(value1)) and the percent, but will carry the value of the amount.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein