topic Re: Simple stacked bargraph in QlikView

Simple stacked bargraph

Mon, 14 Oct 2013 21:23:15 GMT

How do I make a simple stacked bargraph with below data?

X axis is Equipment.

Y axis is stacked Totals of WR and WO

Total	Equipment	Type
6	T5	WR
2	T6	WR
2	T7	WR
6	T8	WR
6	T9	WR
6	T10	WR
6	T11	WR
6	T12	WR
6	T13	WR
6	T14	WR
6	T15	WR
6	T16	WR
6	T5	WR
1	T6	WR
6	T7	WR
6	T8	WR
6	T9	WR
6	T10	WR
6	T11	WR
6	T12	WR
6	T13	WR
6	T14	WR
6	T15	WR
6	T16	WR
6	T5	WO
6	T6	WO
6	T7	WO
6	T8	WO
6	T9	WO
6	T10	WO
2	T7	WO
6	T8	WO
6	T9	WO
2	T10	WO
6	T11	WO
6	T12	WO
1	T13	WO
2	T14	WO
1	T7	WO

Re: Simple stacked bargraph

rustyfishbones — Mon, 14 Oct 2013 21:36:06 GMT

see attached.

Create a Bar Chart

Add Equipment and Type as Dimensions

Expression is Total

and in the style tab choose Stacked radio button

Re: Simple stacked bargraph

Mon, 14 Oct 2013 22:21:20 GMT

This worked.

Now I am trying to add an additional trend line by Equipment only (another column not shown). But when I add a second expression for the trend line, I lose the stacked bar feature.

Re: Simple stacked bargraph

rustyfishbones — Mon, 14 Oct 2013 22:25:12 GMT

can you attach the file of what you have

Re: Simple stacked bargraph

Mon, 14 Oct 2013 22:33:56 GMT

I need to add additional trend line showing FAIL count, by Equipment.

When I add this second expression, I lose the stacked bar feature.

Total

Equipment

Type

Result

Fail

T10

T11

Fail

T12

Fail

T13

Fail

T14

Fail

T15

Fail

T16

Fail

T10

T11

T12

Fail

T13

T14

T15

T16

Fail

T10

Fail

T11

Fail

T12

Fail

T13

Fail

T14

Fail

Re: Simple stacked bargraph

rustyfishbones — Mon, 14 Oct 2013 22:37:12 GMT

I am not sure you can add a trendline and keep the stacked bar Chart.

You can have Combo charts like this, but I am not sure about stacked bars with trendline.

Sorry!

Re: Simple stacked bargraph

Mon, 14 Oct 2013 22:56:08 GMT

According to your “Plant Operations” QVW file it is, but I can’t reproduce this on my relatively simple example dataset.

See the dashboard page. If I changed the graph styles to stacked bar with trend, it stacks and keeps the trend line also.

Re: Simple stacked bargraph

Mon, 14 Oct 2013 22:57:56 GMT

From: Bogart, Susan

Sent: Monday, October 14, 2013 3:56 PM

To: 'jive-1802381019-2yh8-2-8p9f@qliktech-public.hosted.jivesoftware.com'

Subject: RE: - Simple stacked bargraph

According to your “Plant Operations” QVW file it is, but I can’t reproduce this on my relatively simple example dataset.

See the dashboard page. If I changed the graph styles to stacked bar with trend, it stacks and keeps the trend line also.