Discussion Board for collaboration related to Creating Analytics for QlikView.
How do I make a simple stacked bargraph with below data?
X axis is Equipment.
Y axis is stacked Totals of WR and WO
Go to Solution.
Create a Bar Chart
Add Equipment and Type as Dimensions
Expression is Total
and in the style tab choose Stacked radio button
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.
can you attach the file of what you have
I need to add additional trend line showing FAIL count, by Equipment.
When I add this second expression, I lose the stacked bar feature.
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.
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.
From: Bogart, Susan
Sent: Monday, October 14, 2013 3:56 PM
Subject: RE: - Simple stacked bargraph