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 your new qvw as well?

[#3]

Just loaded testqlk3

Thanks for your continued assistance!

[eduardo_sommer]

Hi Jennifer

The problem is in your data. You have records with Account Type= 'Digital Ad Revenue' with value in the [Total Exp] field. So, when you select Digital Ad Revenue, Qlikview will also calculate the sum of [Total Exp]. The same occurs with the 'Print Ad Revenue'. Your app works with Account type = 'Expense', because this is the only account type in your model with only one column with values ([Total Exp]).

Eduardo

[#5]

Then I guess something is awry with my forced concatenation.  I'll try again

[#6]

What is the best way to Join/Concatenate 2 tables that have no rows in common, just most, but not all, column headers?

[eduardo_sommer · Accepted solution]

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

[#8]

I've checked my data and there are no accounts with multiple account types, so I still think it's how I am loading the data, but I have no idea where the issue is

[#9]

You were absolutely right, Eduardo.  I had some stowaway data in my Expenses file.  I'm all fixed now!

[eduardo_sommer]

And did you check if there are no accounts in the wrong spreadsheet? Take a look at the subset of your data below:

Here, you can see data with null in the first and third value and, in the next record, with the fisrt two values as nulls and the same value as the previous record in the third field.

Maybe this records are in both YTD Expense.xlsx and YTD Print Ad Revenue.xlsx

Eduardo