Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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?

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Bar chart- extra bars?

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

28 Replies
Not applicable

Re: Bar chart- extra bars?

Could you share the qvw?

Employee
Employee

Re: Bar chart- extra bars?

Is there data associated with the month Jan?

Are you using a secondary axis?

Not applicable

Re: Bar chart- extra bars?

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

Not applicable

Re: Bar chart- extra bars?

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

Not applicable

Re: Bar chart- extra bars?

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

Re: Bar chart- extra bars?

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

Re: Bar chart- extra bars?

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

Not applicable

Re: Bar chart- extra bars?

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

Not applicable

Re: Bar chart- extra bars?

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.