Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
plimdelondres
Contributor III
Contributor III

re: labels on the axis of a forecast?

I've added a forecast value of three on the axis tab of chart properties:

GP_Prescribing_NHS_Wales_Demo_v1_Screenshot_Axes_ForecastOption.png

and was wondering if there is any way to get some labels on the x-axis after the dates eg: forecastdate1, forecastdate2 etc..

GP_Prescribing_NHS_Wales_Demo_v1_Screenshot.png

1 Solution

Accepted Solutions
Or
Master
Master

There's no inherent way, but there's a workaround you can try and use.

Under "Presentation", add reference text. Enter a formula for the next period (in your case, it would probably be Max(Period)+100). Format it as desired. Using CTRL+SHIFT, drag it to the right side and place it where the label would normally go. Repeat the process for the number of forecast periods you plan to enable.

View solution in original post

8 Replies
Anil_Babu_Samineni

There is no way, But we can add using Island table that necessary to use from reference of island field and which occurs to forecast using Linest_M and Linest_B ..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
plimdelondres
Contributor III
Contributor III
Author

Do you have an example?

Or
Master
Master

There's no inherent way, but there's a workaround you can try and use.

Under "Presentation", add reference text. Enter a formula for the next period (in your case, it would probably be Max(Period)+100). Format it as desired. Using CTRL+SHIFT, drag it to the right side and place it where the label would normally go. Repeat the process for the number of forecast periods you plan to enable.

View solution in original post

plimdelondres
Contributor III
Contributor III
Author

I see! Label dragging. Crude workaround. Thanks!

floating_text.png

Anil_Babu_Samineni

Please attach you application to investigate. And make sure to add inline to reload an Island table.

And, As work around requested - Try to use "Text in Chart" option from presentation tab of each line if report got constant.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
plimdelondres
Contributor III
Contributor III
Author

As per thread. Text in the chart works to my satisfaction. All done now. Thanks everyone!

Anil_Babu_Samineni

I even wonder, How Customer satisfy this review because It may change some where in filter and it compulsi to compute each. And here not sure how they know which is forecast and which is normal data set. Are you going to change any text color? If so, That could be make sense.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
plimdelondres
Contributor III
Contributor III
Author

That is a good point about the line colour. They will know because the verbal commentary will state from which month the forecast begins...