topic Re: Line chart X axis issues - (week) showing earlier data points not present in the dataset in App Development

Line chart X axis issues - (week) showing earlier data points not present in the dataset

MZqlik — Fri, 12 Aug 2022 14:19:25 GMT

Hi There,
On my dataset I have a constrain that only shows dates after 31/03/22.

As you can see, when I hover over the first data point it shows that the date is 01/04/22 - I am wondering why the Line chart X axis which is a week ending number is showing 27/03/21.

I had a look and I can confirm that in the data I don't have anything earlier than 01/04/22.
Does anybody know how I can achieve this?

Re: Line chart X axis issues - (week) showing earlier data points not present in the dataset

Alex_Whatever — Fri, 12 Aug 2022 14:37:51 GMT

Try not to use a Continuous scale

Add-ons -> Data handling -> Include zero values -> turn off

Also, if your [Date] field comes from a separate Calendar table, please make sure you are using "Where Exists()" / "Left Keep ()" / "Where [Date]>=" construction in the script. And check an existed values in the Data Model.

Re: Line chart X axis issues - (week) showing earlier data points not present in the dataset

MZqlik — Fri, 12 Aug 2022 15:03:37 GMT

If I take off the Continuous scale the 27/03/22 disappears but I get some gap at the beginning. It is very odd.

Would you know how to get rid of it?

Re: Line chart X axis issues - (week) showing earlier data points not present in the dataset

romansysyuk — Sat, 13 Aug 2022 07:39:49 GMT

as you can see, there is not enough space for the dimension values:

a) make the chart higher;

b) use VizLib object with option to set amount of dimension values characters;

c) Presentation.Scrollbar = Mini chart; Presentation.Scroll alignment = End; X-axis.Label orientation = Horizontal; X-axis.Number of axis values = Custom; X-axis.Maximum number = {an amount which gives you full dimension values shown without ...};

But! At the very beginning I'd not switch off Continuous scale but rather checked twice a data quality (marked bold in my previous post)

Re: Line chart X axis issues - (week) showing earlier data points not present in the dataset

MZqlik — Mon, 22 Aug 2022 09:18:11 GMT

Hi there,
It's not a matter of making the chart higher; even if I make it bigger, the x-axis stays the same.