Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Tags (2)
1 Solution

Accepted Solutions
rustyfishbones
Honored Contributor II

Re: Simple stacked bargraph

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

7 Replies
rustyfishbones
Honored Contributor II

Re: Simple stacked bargraph

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

Re: Simple stacked bargraph

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
Honored Contributor II

Re: Simple stacked bargraph

can you attach the file of what you have

Not applicable

Re: Simple stacked bargraph

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

Highlighted
rustyfishbones
Honored Contributor II

Re: Simple stacked bargraph

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

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.

Not applicable

Re: Simple stacked bargraph

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.