Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
BlakeGri2093
Contributor III
Contributor III

How to visualize the time series forecast by using qlik sense desktop

Hi guys

i have a problem to visualize the time series forecast output from Alteryx by using Qlik sense desktop (forecast for 30 days). in this pictures, you guys see the historical data and the time series forecast output, when i put 2 files into Qlik sense the association between historical data and output time series are really weak and it couldn't the visualization the output that i want. Can anybody give me the ideal for this problem ?
Table 1: Output data (from 1/1/2019 - 30/1/2019)

forecast_oilforecast_oil_high_80forecast_oil_high_70forecast_oil_low_70forecast_oil_low_80Date
88.4388526990.4959175890.1024695186.7752358786.3817877901/01/2019
88.4233114790.5798666790.1673894186.6792335486.2667562802/01/2019
88.4181784690.6698322290.2391657786.5971911586.166524703/01/2019
88.4180769690.7609723990.3128544486.5232994886.0751815404/01/2019
88.4312228890.8619374590.3970226286.4654231486.0005083105/01/2019
88.3922158690.9076855390.4265598786.3578718585.876746206/01/2019
88.4442842991.0417449790.5449371686.3436314285.8468236207/01/2019
88.4677211491.1539623390.6401737786.2952685185.7814799408/01/2019
88.4067054491.1726595890.6436245886.1697862985.6407512909/01/2019
88.4418039891.2852372890.7413830986.1422248885.5983706910/01/2019
88.4453914191.3642479490.805967886.0848150285.5265348811/01/2019
88.4621309291.4545102490.8821676486.042094285.469751612/01/2019
88.4017048891.4658433590.8797756185.9236341585.3375664113/01/2019
88.4059965791.5402516890.9407729685.8712201885.2717414514/01/2019
88.4231388791.6658663591.0456404885.8006372785.1804113915/01/2019
88.4231388791.7434409491.1083776285.7379001285.102836816/01/2019
88.4231388791.8192440191.1696820985.6765956585.0270337317/01/2019
88.4231388791.8933916691.2296477685.6166299884.9528860818/01/2019

Table 2: Historical data (from 2011 - 2018)

DatePrice of Crude Oil/ barrel (USD)
01/01/201192.19
02/01/201192.54
03/01/201192.86
04/01/201192.76
05/01/201192.91
06/01/201192.79
07/01/201192.20
08/01/201192.93
09/01/201192.66
10/01/201192.28
11/01/201193.01
12/01/201192.29
13/01/201192.62
14/01/201192.73
15/01/201192.76
16/01/201192.50
17/01/201192.77
18/01/201192.40
19/01/201192.46
20/01/201193.06
21/01/201192.50
22/01/201192.49
23/01/201192.92
24/01/201192.52
25/01/201192.42
Labels (1)
2 Replies
crusader_
Partner - Specialist
Partner - Specialist

Hi,

Not sure what the problem is, but have a look into YEAR... your forecast has 2019, but historical file 2011. Do you want to put them on the same graph with a gap in 8 years?

//Andrei

BlakeGri2093
Contributor III
Contributor III
Author

i have full historical data from 2011 - 2018( day,month and year) and i use the time series forecast in Alteryx to get the output forecast for 2019 (forecast by day). But i don't know the way to visualize the output connect with the historical data