Suggest an Idea

[briwilli]

Our client has data that contains a year dimension where the year values are not sequenced in a consistent manner over time, such as data for years: 1993, 2003, 2010, 2013, 2015, etc..  When this data is rendered in a line chart, the spacing is consistent between all year data points,  so the spacing between 1993 and 2003 is the same as between 2013 and 2015.   This can result in a misleading line chart as the rate of change between 1993 and 2003 can appear to be the same as between 2013 and 2015 when it reality the first change is over a 10 year span as oppose to a 2 year span.  Our client has requested that we submit a request for Qlik to consider adding a feature to autogenerate dates or years to fill in the missing data gaps and produce a line chart that is proportional to the overall range of years.   

[SimonBall]

could you create a year calendar of all the years from current min to current max and use that as the dimension to achieve the aim without a code change

[briwilli]

Thanks Simon, that is the approach we are taking.

[Meghann_MacDonald]

Hi, we will put this through to Product review but the workaround suggested using standardized calendar of years and unselecting "Remove Nulls" to show years that have 0 values is recommended as a solution.

Meghann

[briwilli]

I implemented a calendar as recommended but it is still not exactly what our client wants, so to help explain what she is asking for I've  captured the issue with the following 3 screen shots:

The first image shows the original problem we faced.  The chart is misleading in that it show the same spacing between the data points of 1993 - 2003 and between 2013 - 2015, so it appears there is a sharp decrease in counts between 1993 and 2003 when in fact it is much more gradual :

The second image shows the same line chart using the recommended calendar of years:

The problem our client has with the above line chart is that it may appear to the user viewing the chart that for some years there is a zero count, for instance years 1994 - 2002 show data points of 0 and that is not the case since in reality we have no data for those years.  Our client would prefer that the lines go between data points that contain data instead of down to 0.  I've mocked this up in the image below:

 Question, is there a way to render the above line chart using the calendar of years?  Or is there some other way I can generate this type of chart? 

Thanks
Brian 

[Patric_Nordstrom]

Can be done today. Make sure Year is a date, switch to continuous scale:

And sett missing values to be shown as connections

Thanks,

Patric