Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple stacked bargraph

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 EquipmentType
6T5WR
2T6WR
2T7WR
6T8WR
6T9WR
6T10WR
6T11WR
6T12WR
6T13WR
6T14WR
6T15WR
6T16WR
6T5WR
1T6WR
6T7WR
6T8WR
6T9WR
6T10WR
6T11WR
6T12WR
6T13WR
6T14WR
6T15WR
6T16WR
6T5WO
6T6WO
6T7WO
6T8WO
6T9WO
6T10WO
2T7WO
6T8WO
6T9WO
2T10WO
6T11WO
6T12WO
1T13WO
2T14WO
1T7WO
1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

see attached.

Create a Bar Chart

Add Equipment and Type as Dimensions

Expression is Total

and in the style tab choose Stacked radio button

2013-10-14_2225.png

View solution in original post

7 Replies
rustyfishbones
Master II
Master II

see attached.

Create a Bar Chart

Add Equipment and Type as Dimensions

Expression is Total

and in the style tab choose Stacked radio button

2013-10-14_2225.png

Not applicable
Author

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.

rustyfishbones
Master II
Master II

can you attach the file of what you have

Not applicable
Author

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

6

T5

WR

Fail

2

T6

WR

2

T7

WR

Fail

6

T8

WR

6

T9

WR

6

T10

WR

6

T11

WR

Fail

6

T12

WR

Fail

6

T13

WR

Fail

6

T14

WR

Fail

6

T15

WR

Fail

6

T16

WR

Fail

6

T5

WR

Fail

1

T6

WR

Fail

6

T7

WR

6

T8

WR

6

T9

WR

6

T10

WR

6

T11

WR

6

T12

WR

Fail

6

T13

WR

6

T14

WR

6

T15

WR

6

T16

WR

6

T5

WO

Fail

6

T6

WO

Fail

6

T7

WO

Fail

6

T8

WO

Fail

6

T9

WO

Fail

6

T10

WO

2

T7

WO

6

T8

WO

6

T9

WO

2

T10

WO

Fail

6

T11

WO

Fail

6

T12

WO

Fail

1

T13

WO

Fail

2

T14

WO

Fail

1

T7

WO

rustyfishbones
Master II
Master II

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!

2013-10-14_2326.png

Not applicable
Author

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.

Not applicable
Author

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.