Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Visualization and Usability

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!

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