Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Linear Trend with Calendar Table

Hi everyone!  Trend lines seem to be above my head in Qlik Sense.....

I have a measure that I want to graph over time, preferably using my Calendar table, including a linear trend line.

1)  I want the x-axis to be by Year-Month, which I have defined as a column in the Calendar table, BUT, the linear trend formula doesn't seem to accept text values.

2)  If I use just the base Date from the Calendar table, it plots correctly, but there are two issues:

Issue #1:  Since my calendar table extends further into the future than my measure, I have lots of dead space due to the inclusion of the trend line.

Issue #2:  The plot is by day rather than Year-Month.  Anytime I try to change the Date format, I lose the trend line.

Any wisdom on this?  This feels like a big gap for Qlik, as it was super easy in Power BI.  Any help is very much appreciated!

Linear Trend Issues.PNG

Labels (5)
0 Replies