Total Trendline Over Stacked Bar Chart

[Anonymous]

Hi Everyone,

I've been researching this issue, as it seems like it'd be a common thing, and so far the threads I've found haven't had answers that I a) understand and b) know how to apply.

I have a stacked bar chart, based on 2 dimensions (date and type) relative to an expression of a total count of IDs. In a nutshell, the different types stack up, but the only trendlines you can get are for each individual type.

Ideally, I'd like the trendline at the top, showing the trend of the total IDs between the dates.

I've attached a super basic qlikview form of the chart setup, with the trendlines flagged on to show where they currently sit.

Any help would be greatly appreciated.

[vinieme12]

You can add a reference line from the presentation tab as below

try below expression for Average

     =count(distinct  ID)/count(distinct  total date)

[marcus_malinow]

Hi Michael,

if I understand your question correctly, the link below may be able to help:

https://community.qlik.com/message/1004951#1004951

Basically, the approach highlighted is to have two charts - one with stacked bars, and a second to display your trendline. By using transparency in your charts you can get one chart overlaid on top of the other. Not a particularly elegant solution IMHO, but seemingly the only one which would deal with this issue.

Marcus

[vinieme12]

OR create a separate expression for each stack value

[Anonymous]

I don't have access to that page just yet, but I will check it out when I do.

I think I see what you're saying though, Marcus. It's an innovative solution, but you're right it's not the most elegant. Still, if it gets the job done it might have to work.

[Anonymous]

While this does work on the surface, I opted against it because you can't click into each segment to isolate the IDs. The ability to click type 'a' and see the 3 in 7/23 and the 2 from 8/23 is the goal.

With the expression method here, I can only click the date and then can go no further into the information.

Thanks

[sunny_talwar]

This is not perfect, but see if this works

[Anonymous]

Very interesting solution... I'll see if I can finagle something similar with my main project. Else, I'll be doing what Marcus mentioned with the stacked charts.

Thanks Sunny