New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION

Who Me Too'd this solution

Michael_Tarallo
Employee
Employee

See attached .QVF - copy to: C:\Users\<user profile>\Documents\Qlik\Sense\Apps, restart Sense or press F5 - in the hub after copying if Sense is open. Launch the Trend app.

Please let me know if this is what you are after.

The expression below needs to be used and calculated as a new measure in combination with a combo chart:

linest_m(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)*

only({1}OrderDate)+linest_b(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)

8-17-2014 8-40-00 PM.png

Regards,
Mike Tarallo
Qlik

View solution in original post

Who Me Too'd this solution