topic Re: Total Trendline Over Stacked Bar Chart in QlikView

Total Trendline Over Stacked Bar Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Total Trendline Over Stacked Bar Chart

vinieme12 — Wed, 23 Aug 2017 12:28:11 GMT

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

try below expression for Average

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

Re: Total Trendline Over Stacked Bar Chart

marcus_malinow — Wed, 23 Aug 2017 12:29:34 GMT

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

Re: Total Trendline Over Stacked Bar Chart

vinieme12 — Wed, 23 Aug 2017 12:37:49 GMT

OR create a separate expression for each stack value

Re: Total Trendline Over Stacked Bar Chart

Anonymous — Wed, 23 Aug 2017 12:58:44 GMT

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.

Re: Total Trendline Over Stacked Bar Chart

Anonymous — Wed, 23 Aug 2017 13:01:24 GMT

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

Re: Total Trendline Over Stacked Bar Chart

sunny_talwar — Wed, 23 Aug 2017 13:18:47 GMT

This is not perfect, but see if this works

Re: Total Trendline Over Stacked Bar Chart

Anonymous — Wed, 23 Aug 2017 13:37:23 GMT

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