Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

benoitgochel
New Contributor III

% Based stacked bar chart

Hi all,

I have a stacked bar chart with two dimensions (Employee and SubGroupProject) in order to analyze the timesheets of the employees.

The timesheets are transactions lines with a quantity of hours and a projet-subGroupProjet-GroupProjetc.

I would like to show with a stacked bar chart the repartition in % of subGroupProject for each employee.

Eg :

Untitled.png

But with % repartition for every employee.

I tried  :

=num(SUM([#Hours.QTY])/SUM(TOTAL(<[empl.name]>[#Hours.QTY]))) as my meseaure expression

But I got no result ...

What can I do to solve this?

Thank you in advance,

1 Solution

Accepted Solutions
MVP
MVP

Re: % Based stacked bar chart

Try this

=Num(Sum([#Hours.QTY])/Sum(TOTAL<[empl.name]> [#Hours.QTY]))

3 Replies
shraddha_g
Honored Contributor III

Re: % Based stacked bar chart

Please Share sample app or sample data

MVP
MVP

Re: % Based stacked bar chart

Try this

=Num(Sum([#Hours.QTY])/Sum(TOTAL<[empl.name]> [#Hours.QTY]))

benoitgochel
New Contributor III

Re: % Based stacked bar chart

It worked.

Thank you very much.