Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
tizianonear
New Contributor

Expression in bar charts with multidimension

Hi,

I have a table like this:

YearKeyFieldTypeValue
2008001ObjectA2
2008001ObjectB3
2008001PlayerA18
2008001PlayerB3
2008001BookA7
2008001BookB12
...............

and I want to creare a "Horizontal Stacked Bar Chart"  with dimension:

Stack = Key

Bar = Field

and measures:

(Sum(Value)/sum(total(Value)))

Measures need to show the percent.

It show in this way:

Screenshot (51).png

but I need to show something like this:

Screenshot (52).png

I think that I need to modify the Measure expression to calculate the percent in a way that is right to take the full value, but I don't know how.

Thanks to all

2 Replies
Partner
Partner

Re: Expression in bar charts with multidimension

could you attach a sample app woth mock data?

Partner
Partner

Re: Expression in bar charts with multidimension

try this Sum(Value)/sum(total<Key> Value)

personal e.g. below


Capture.PNG

Sum(LineSalesAmount)/Sum(total<Year>  LineSalesAmount)

Year is the stack