Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rajender_qlik
Creator
Creator

TrendLine values

Hello,

I have a requirement where we plot some data and have some set alert lines for the data in green color. I have used linear trendline for the data to fit and has some equation. I want to know the date in the future when the trendline will cross the alert low or alert high line which is in green.

How can I calculate this date in the future in qlikview ?

I am attaching a screenshot below.TrendLine Date.PNG

Any suggestions are appreciated.

1 Solution

Accepted Solutions
rajender_qlik
Creator
Creator
Author

Type of, but its calculating the date when it will cross the alert high in the future with the equation.

View solution in original post

3 Replies
MK9885
Master II
Master II

Is this permutation and combination type of questions?

rajender_qlik
Creator
Creator
Author

Type of, but its calculating the date when it will cross the alert high in the future with the equation.

MK9885
Master II
Master II

I'm sure i'm not the right person to answer this but by just looking at image and 'some expression' wouldn't help much either.

Permutations Math | Qlik Community

Creation of Lottery Permutations via load script

hopefully someone can help you and I can also learn something new.