topic Re: Bridge chart with multiple expressions in QlikView

Bridge chart with multiple expressions

zekazak — Tue, 25 Jul 2017 17:23:00 GMT

Hello guys,

I need some advice of designing a bridge chart. I'vo got a pivot looking like this:

Where:

- Attributed Starts = sum({<[Channel Type]={'Attributed'} >}Volume)

- Lat Touch Starts = sum({<[Channel Type]={'Last Touch'} >}Volume)

- Var = [Attributed Starts]-[Last Touch Starts]

The goal is to build a bridge chart which would look like this:

Any help would be much appreciated.

Best Regards,

~Sergejs

Re: Bridge chart with multiple expressions

Anil_Babu_Samineni — Wed, 26 Jul 2017 09:41:15 GMT

PFA

Re: Bridge chart with multiple expressions

zekazak — Fri, 28 Jul 2017 12:38:04 GMT

Thanks for this. It might be helpful. But in my case this list of variances is could be short or very long (up to 50). Not sure that the chart will perform well when having 50 expressions in it. And reference lines is not that business expected.

Best Regards,

~Sergejs

Re: Bridge chart with multiple expressions

Anil_Babu_Samineni — Tue, 01 Aug 2017 10:39:59 GMT

I can look, If you provide sample application in real data set