Scaling a grid chart or getting the scatter chart to work - Qlikview
Hi All. I'm calling on your guidance, as I am stuck, and despite much time googling and trawling through similar questions, I can't seem to find an answer
I am currently trying to create a form of scatter chart that gives me a chart of weights (Y axis) by Date (x axis) demonstrated by customer.
A grid chart gives this to me, but I can not get this to scale. The image below provides an example of this. We should have 'Tonnage' up to 32 tonnes, yet I only see this scaled to 8. Re-sizing the chart allows more to be included, however this isn't necessarily practical and does not necessarily resolve the problem.
If I try and create this via a Line chart, the scaling works fine, but it averages my weights where I need to effectively show the raw data - a weight for each ticket number (although I don't want to or need to show the ticket). If I try and set it up as a Scatter, it wants 2 numerical expressions.
I may be the way I'm approaching this or my calculations, but any advice is greatly appreciated.
This it to keep the grid chart from populating every spot on the grid. At this point the chart looked like my original problem. To scale, add an expression with a constant value. I just added 1. This shows every Y-axis every value you autogenerated. If you want to reduce the Y-axis to limit to range of the values, change the constant expression to:
If(Avg(ScoreAxis)>=Min(TOTAL Aggr(Avg(Score),Location)) and Avg(ScoreAxis)<=Max(TOTAL Aggr(Avg(Score),Location)),1)
I have attached an example.
Unfortunately, this workaround will require you to round the expressions to be able to link with the scaled axis.