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?
Solved! Go to 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
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
See this link for many topics on synthetic keys and how to remove them.