Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The picture on the left is what I have in QlikView. The picture on the right is what I have in Excel. How can I make the picture on the left look like the picture on the right? QV file is attached.
Think so, Stacked bar charts can be created in two ways:
1. Two Dimensions, one Measure.
2. One Dimension, multiple Measures.
In order to create the chart in the first case, you need to load your data using the CROSSTABLE load. This way, your Field1, Field2, Field3 labels get loaded as values of an "Attribute Field" and your numeric totals get loaded as the "Data Field". The sum(Data Field) can serve as your Measure.
Otherwise, you can create a stacked bar chart with multiple measures:
sum(Field1)
sum(Field2), etc...
then, you don't have to do anything with your data structure.
Otherwise, created a flag to differentiate between some fields
It has been used in as a secondary dimensionin the bar chart.
And also check this link:
May be like this:
Br,
KC
Thanks so much. This worked perfectly. And I just learned how to add a cross table.
Who knew??
Can i ask one more question? I am trying to add variables to the crosstab. This is what my two tables look like now. I would like the crosstab to sort by all the applicable fields.