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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel
MVP
MVP

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
MVP
MVP

search for


linest_m()

regards

Marco

jduenyas
Specialist
Specialist
Author

Thanks Marco

It may help

MarcoWedel
MVP
MVP

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
MVP
MVP

you're welcome

regards

Marco