display total and detail numbers in a graph

[#1]

Hi Qlik guru's

I need to display, In a stacked bar charts the detail values and the Total Values.

Like a combination of both graphs attached.

I don't mind if the total numbers are on the top or close to the axis.

Any idea?

Cheers,
Eva

[aveeeeeee7en]

See the Attachment.

Regards

Av7eN

[Sokkorn · Accepted solution]

Hi Eva,

Please see my idea in attached file.

Regards,

Sokkorn

[#4]

Unfortunately, I don't know how many Dim values I will get.

:S

I updated my file with expected result.

[#5]

Sokkorn, You are my master!!1 You rocks.

Thanks a lot

[aveeeeeee7en]

Hi Eva

There is one more alternative.

Following is the Snapshot:

See the Attachment.

Regards

Av7eN

[#7]

Dear master Sokkorn,

A last question,

In the real data set I get an alignment bizarre.

Do you know how I can align everything?

Eva

[Sokkorn]

Hi Eva,

You may try by:

1. Click on bar chart object

2. Hold down Ctrl+Shift

3. Move red line base on your desire.

Just call my name is enough . No need master.

Regards,

Sokkorn

[#9]

I just found a solution for the alignment problem.

Add a nodistinct in the formula and the text in white if the RowNo() >1

So far I didn't get why that append

Thanks a lot for you help.

Cheers,

[Sokkorn]

Hi Eva,

Nice!!! and thanks for share solution.

Regards,

Sokkorn