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

Bar chart- extra bars?

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?

1 Solution

Accepted Solutions
eduardo_sommer
Partner - Specialist
Partner - Specialist

I took a look in your data and found that you have a lot of accounts with 2 account type. Create a straight table in your app to see this. In the dimension, select Accounts and for the expression, write -count([Account Type]). Order the straigt table, Now you'll see all the accounts with 2 Account Type

Probably, you have a problem with your data

Eduardo

View solution in original post

28 Replies
Not applicable
Author

Could you share the qvw?

Greg_Williams
Employee
Employee

Is there data associated with the month Jan?

Are you using a secondary axis?

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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.