topic Re: Bar chart- extra bars? in QlikView

Bar chart- extra bars?

Thu, 05 Jun 2014 15:11:42 GMT

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?

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:13:02 GMT

Could you share the qvw?

Re: Bar chart- extra bars?

Greg_Williams — Thu, 05 Jun 2014 15:14:44 GMT

Is there data associated with the month Jan?

Are you using a secondary axis?

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:17:48 GMT

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

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:18:07 GMT

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

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:18:45 GMT

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

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:30:01 GMT

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

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:32:58 GMT

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

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:34:56 GMT

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

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:36:16 GMT

http://community.qlik.com/search.jspa?peopleEnabled=true&userID=&containerType=&container=&spotlight=true&q=remove+synth…

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

Re: Bar chart- extra bars?

Anonymous — Thu, 05 Jun 2014 15:38:58 GMT

Hi Jennifer,

Take a look at the design blog post by Henric Cronstrom...

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys

Synthetic keys should be resolved in the data model as they can/will give you spurious results in your app. There are a number of resources to help you, including the Qlik training courses. Free on-line training also exists on the Qlik website here.... QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik

Cheers.

Adam.

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:51:27 GMT

Thanks everybody! Since ultimately, I will be working with very large data sets, I don't think a Link table will be viable due to the number of combinations involved.

I'm going to look into consolidating my data and try to figure out how to split the display of the data in my chart, somehow.

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:53:18 GMT

Yes it is, that is the synthetic table that qlikview will automatically generate for you.

You can either join or concatenate tables to get rid of them, if they are related values.

If not, you can rename fields if they are distinct sets of values and that will solve the problem as well.

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 15:54:02 GMT

QlikView – Resolving Synthetic keys | Learn QlikView

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 16:07:08 GMT

Yeah, I am stuck. Here is my basic structure, I have 3 tables which have identical columns, but different data. I have this set up to allow each set of data to feed a separate expression in charts.

I have three more tables which translates values/consolidates data from each of the data tables into higher-level views

I have a Month table, just to force a custom sort on the Month variable.

If I rename the fields from each of the data tables, they will no longer tie to the consolidation tables.

If I consolidate the data tables, I can't use the 3 sets of data (based on account type, for now) as separate expressions, at least I can't figure out how to do it.

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 16:11:39 GMT

The easiest thing to do may be to join your tables so that you have one table with all three totals

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 16:15:48 GMT

oh that is smart. Just reading up on Joins now. Thanks!

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 16:15:59 GMT

Try outer joining print ad revenues, expenses, and dig ad revenues

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 16:38:02 GMT

I think you should invest more time in theory

The best way i think is to have all the 3 measures (in one row) in a fact table if this is possible. Read something about scripting, concetenation, joins, synthetic keys...
Data model is at least so or more important as a visualization layer in an app.

Do you posses basic knowledge of BI theory?

Re: Bar chart- extra bars?

Thu, 05 Jun 2014 17:17:41 GMT

Unfortunately, I have eliminated my Syn table and the bar chart problem still exists.

Here's my Table Viewer

Full chart- this is fine, though it needs formatting cleaned up

Listbox selection chart-