topic Re: display total and detail numbers in a graph in QlikView

display total and detail numbers in a graph

Mon, 20 Oct 2014 04:15:17 GMT

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

Re: display total and detail numbers in a graph

aveeeeeee7en — Mon, 20 Oct 2014 04:22:28 GMT

See the Attachment.

Regards

Av7eN

Re: display total and detail numbers in a graph

Sokkorn — Mon, 20 Oct 2014 04:37:08 GMT

Hi Eva,

Please see my idea in attached file.

Regards,

Sokkorn

Re: display total and detail numbers in a graph

Mon, 20 Oct 2014 04:37:48 GMT

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

I updated my file with expected result.

Re: Re: display total and detail numbers in a graph

Mon, 20 Oct 2014 04:41:54 GMT

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

Thanks a lot

Re: display total and detail numbers in a graph

aveeeeeee7en — Mon, 20 Oct 2014 04:52:24 GMT

Hi Eva

There is one more alternative.

Following is the Snapshot:

See the Attachment.

Regards

Av7eN

Re: Re: display total and detail numbers in a graph

Mon, 20 Oct 2014 05:07:16 GMT

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

Re: display total and detail numbers in a graph

Sokkorn — Mon, 20 Oct 2014 05:48:37 GMT

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

Re: Re: display total and detail numbers in a graph

Wed, 22 Oct 2014 00:31:35 GMT

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,

Re: Re: display total and detail numbers in a graph

Sokkorn — Wed, 22 Oct 2014 00:38:48 GMT

Hi Eva,

Nice!!! and thanks for share solution.

Regards,

Sokkorn

Re: display total and detail numbers in a graph

Wed, 22 Oct 2014 00:59:30 GMT

On the Dimension Limits, there is an Option Show Total check box. It will add a new bar to the chart..

Re: display total and detail numbers in a graph

Wed, 22 Oct 2014 01:08:26 GMT

It doesn't works, the purpose is showing the total per month, not the Grand Total.