topic 100% Stacked Bar Graph in QlikView

100% Stacked Bar Graph

Mon, 16 Apr 2012 16:02:05 GMT

Hi,

I'm having trouble getting a 100% Stacked bar graph working.

I have 2 dimensions:

Month

Hour Range

The Hour Range consists of: 0-4, 4-8, 8-12, 12 +

I would like a graph that shows for each month what percentage is made up of which hour rage.

Hope this makes sense. I can't seem to get the expression to work.

Thanks in advance.

Simon

100% Stacked Bar Graph

Jason_Michaelides — Mon, 16 Apr 2012 16:30:43 GMT

Try SUM(Sales)/SUM(TOTAL <Month> Sales)

Month should be the first dimension, then Hour Range.

Hope this helps,

Jason

100% Stacked Bar Graph

Tue, 17 Apr 2012 09:28:58 GMT

Thanks for the quick reply, but no joy.

I'll try and be more descriptive.

I have a field called ATAMonth which can contain each month i.e Apr, May, Jun, July etc..

I also have a field TimeGroup which can contain '0-4', '4-8', '8-12', 12+

I would like a stacked graph that shows each month and the percentages for each TimeGroup.

This is how I have converted your example, but it does not disaplay the data. Is this correct?

SUM(TimeGroup)/SUM(TOTAL <ATAMonth> TimeGroup)

Cheers

Simon

100% Stacked Bar Graph

CELAMBARASAN — Tue, 17 Apr 2012 09:36:28 GMT

Hi,

I think here you should use count instead of sum

Count(TimeGroup)/Count(Total <ATAMonth> TimeGroup)

ATAMonth should be dimension

Celambarasan

100% Stacked Bar Graph

jagan — Tue, 17 Apr 2012 09:56:20 GMT

Hi,

As Celambarasan said it should be count, if you need sum, there must be cause which has Time from which the TimeGroup is arrived. Check table whether there is any field.

Regards,

Jagan.

100% Stacked Bar Graph

Jason_Michaelides — Tue, 17 Apr 2012 12:38:13 GMT

It'll be something along these lines. If you can post your app we can provided more reliable help.

100% Stacked Bar Graph

Tue, 17 Apr 2012 12:53:47 GMT

Thank you all for your help.

Changing it to count worked once I deleted my graph and recreated it.

Thank you once again,

Simon