I've run into another strange issue with this simple chart I'm trying to plot. I'm trying to show 2 measures (Ph and Chlorine levels) from different Sample Sites (SiteIDs) in pressure zone areas (selected from a list box) over time (at a Yearly).
The Chlorine Level (shown as bars) are displaying fine, but the Ph Level are doing something very strange, for each year the values are getting displayed as a vertical line, instead of being spread out across the different sites.
I verified the data with source files and the aggregated pH values are in fact correct at the SiteID, Year level; so i'm not sure why the data isn't plotted over each SiteID in the x-axis.
Chart preview with the pH line (in blue) showing all the values across different sites in a vertical line.
Could be a data model issue -- It looks like the pH levels are not associated with the site.
Here's the data model, there's a link between Site and pH levels and Chlorine levels. This issue happens with Chlorine Levels in the Combo chart, if it's plotted as a Line instead of a bar.. and when pH is plotted as a bar it shows up as different values for each Site and Year combination. I wonder what the reason is! It's only been a week since I started using Qlikview and so help from the expereinced users here is much appreciated!
I noticed another thing. If I remove the Year dimension and restrict the chart to showing values aggregated to just the Site alone, then the measure plotted as a line display correctly - at the Site level.
>>Here's the data model, there's a link between Site and pH levels and Chlorine levels.
There is no date link between the two parts of your model. In particular, there is no relationship between the dates in the two calendars. These links will provides some guidance on how to design a data model:
Thank you for sharing those resources.
But in the chart concerned, we are only using the dates from the calendar linked to it - Bac_Year ...
Two master calendars have been added to the model since there is no business relationship between the dates for Bacteria tests and Filtration plant. And to avoid a circular reference two tables have been loaded as they have 2 dimensions: this approach is shown in Hic's blog post here: Circular References
In an earlier version of the data model with a linktable, with a single date dimension - the same issue was present.
As shown here.
As long as there is no date link between the parts of the model, you will have those issues. This article may help solving how to handle multiple dates: