Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Autogenerate sequenced dimension values for line chart so that spacing between data points is proportional

briwilli
Contributor III
Contributor III

Autogenerate sequenced dimension values for line chart so that spacing between data points is proportional

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.   

5 Comments
SimonBall
Partner - Contributor II
Partner - Contributor II
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
Contributor III
Contributor III

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
Contributor III
Contributor III

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 :
NoRange.PNG

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

WithRange.PNG

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:

NoGaps.png

 

 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
Employee
Employee

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

 

Patric_Nordstrom_1-1642435484131.png

And sett missing values to be shown as connections

Patric_Nordstrom_0-1642435392311.png

 

Patric_Nordstrom_2-1642435869424.png

 

 

Thanks,

Patric

Status changed to: Closed - Already Available