Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

TREND function

Hi all

Is there a TREND function, except for the visual linear trend line in the Expression tab, which will tell me if a trend is positive or negative over a given period?

If a trend is negative over 3 (or 4, or 5) months I would like to show a red arrow pointing down or green arrow pointing sideways or up depending on the trend direction.

Thanks

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one example using this function:

QlikCommunity_Thread_198952_Pic1.JPG

QlikCommunity_Thread_198952_Pic2.JPG

QlikCommunity_Thread_198952_Pic3.JPG

QlikCommunity_Thread_198952_Pic4.JPG

hope this helps

regards

Marco

View solution in original post

5 Replies
MarcoWedel

search for


linest_m()

regards

Marco

jduenyas
Specialist
Specialist
Author

Thanks Marco

It may help

MarcoWedel

Hi,

one example using this function:

QlikCommunity_Thread_198952_Pic1.JPG

QlikCommunity_Thread_198952_Pic2.JPG

QlikCommunity_Thread_198952_Pic3.JPG

QlikCommunity_Thread_198952_Pic4.JPG

hope this helps

regards

Marco

jduenyas
Specialist
Specialist
Author

Exactly what I was looking for!

Thanks Marco

MarcoWedel

you're welcome

regards

Marco