topic Re: Design a Route in Qlikview in QlikView

Design a Route in Qlikview

Tue, 15 Mar 2016 17:50:08 GMT

Hi experts,

I've the the application in annex and want to build a route based on my data model that have two tables:
1) That defines the route based on the time that customer enter in a local
2) That defines the position of each local

My objective is to build something like this:

Basically I need to design the route of my customer... where he begins? for where did he goes after that? Where did he ends?

Anyone have any better idea?

Thanks!

Re: Design a Route in Qlikview

arthur_dom — Tue, 15 Mar 2016 18:12:48 GMT

Something like this?

Re: Design a Route in Qlikview

Tue, 15 Mar 2016 18:26:17 GMT

Thanks for your response Arthur
I prefer have a more clear view of of the sequences of customer steps.. Basically I want to build the customer journey.

My "dream" is someting like this

Someting that can give you the oportunity to see where process starts and ends, and what was the steps that the customer do...

Re: Design a Route in Qlikview

johnw — Tue, 15 Mar 2016 18:56:41 GMT

Note sure exactly what you're after, but probably some version of a scatter chart with two dimensions.

Re: Design a Route in Qlikview

arthur_dom — Tue, 15 Mar 2016 19:12:47 GMT

Not a problem... same principle, more steps only... I quickçy done this:

Re: Design a Route in Qlikview

johnw — Tue, 15 Mar 2016 19:21:56 GMT

To add the path, add a second dimension, even a calculated dimension like =1. Looks pretty good to me.

Re: Design a Route in Qlikview

MarcoWedel — Tue, 15 Mar 2016 22:41:36 GMT

Hi,

similar to other solutions but maybe also helpful:

regards

Marco

Re: Design a Route in Qlikview

Saravanan_Desingh — Wed, 16 Mar 2016 01:10:01 GMT

Thank you, Marco. I just realized, Dual can be used as Calculated Dimension...