Bar chart- extra bars?

[#1]

First day in QlikView and I'm having an issue with a bar chart.

The chart has 3 expressions and 1 dimension.  There is an associated listbox for the expressions.  If the user does not make a selection, than all three expressions are displayed.  If the user selects an item, the intention is for them to only see 1 bar per dimension.

My dimension is Month (Jan-Jun)

My Expressions are Digital Revenue Print Revenue and Expense.

When the user chooses "Expense", the chart displays properly.

When the user chooses either of the other 2 expressions, the chart displays a bar for the selected expression and then a second bar for the same value, in the color assigned to "Expenses".  This doesn't happen for the month of Jan, but does for all other months.  I've checked the data tables and they're clean.  I'm thinking I have a setting wrong somewhere, any ideas?

[#2]

Could you share the qvw?

[Greg_Williams]

Is there data associated with the month Jan?

Are you using a secondary axis?

[#4]

Added the qvw to the original post, couldn't see how to add to a reply.

[#5]

Yes, there is data for January.  No, no secondary axis.

[#6]

I should mention, I am on a demo version for now, as my boss wants me to test capabilities and ease of use.

[#7]

I think a part of the problem may be in the fact that you have a synthetic table and some of your values are linked together.  You may want to try to optimize that and the problem should go away

[#8]

Is that the Syn1 table that was autogenerated when I loaded all of my tables?  What can I do about that?

[#9]

Robert is correct. Your data model may contain errors. You can view your data model by pressing CTRL+T

[#10]

http://community.qlik.com/search.jspa?peopleEnabled=true&userID=&containerType=&container=&spotlight...

See this link for many topics on synthetic keys and how to remove them.