Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mattjriley85
Not applicable

Cumulative Sales Reference Line

Hi,

I created a line chart with a dimension for day of sales transaction day([mydatefield]) and a measure for the cumulative sales.  what i would like to have in the chart is a reference line that is also a cumulative line across the days of the month.  this would be used to compare the pace of actual sales vs the rate to meet the monthly goal.

i have tried a few expression in the reference line expression area but all have failed.  would anyone know a way to accomplish this?

Thanks

1 Solution

Accepted Solutions
Michael_Tarallo
Not applicable

Re: Cumulative Sales Reference Line

Hi Matt,

I believe the reference line feature is just for a straight line that can be hard-coded or calculated to represent a single value. You may need to use a Combo chart with another calculated expression measure to perform as the reference line. Take a look at this thread where the request is similar - where they are using the calculated measure to plot a trend line:

How to add lineal trend in Qlik sense

Let me know if this puts you in the right direction.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
2 Replies
rupamjyotidas
Not applicable

Re: Cumulative Sales Reference Line

can you share your app

Michael_Tarallo
Not applicable

Re: Cumulative Sales Reference Line

Hi Matt,

I believe the reference line feature is just for a straight line that can be hard-coded or calculated to represent a single value. You may need to use a Combo chart with another calculated expression measure to perform as the reference line. Take a look at this thread where the request is similar - where they are using the calculated measure to plot a trend line:

How to add lineal trend in Qlik sense

Let me know if this puts you in the right direction.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik