in Geoanalytics Idevio Line Layer how to set up Drilldown

[Anonymous]

We are using Line Layer in Geo Analytics how can i set up drill down option. I will have order origin dimension ( Country  State & City  and Destination dimension ( country , State & City) and on the line it will show me order quantity. Now the question is initially when the app is opened the map should show country wise origin to destination countries lines where the order transaction took place. When i drill down into one of the country it should show me states. Please see below screen shot to explain more. If needed i can upload the qvf file. thanks for your help.

mto

[Patric_Nordstrom · Accepted solution]

Hi Vinay,

Yes, drill down with line layers can be done, it's little tricky since you need two have two dill down groups, one for the origin and one for the destination and build measures for start and end that depends on the drill down level.

Use calculated dimension as the the line layer, something like this "origin-dest", (I used count distinct since getcurrentfield is not present in sense):

=if(count(total distinct OriginCountry)>1, OriginCountry) &

if(count(total distinct OriginCountry)=1 and count(total distinct OriginAdm1Id)>1, OriginAdm1Id) &

if(count(total distinct OriginCountry)=1 and count(total distinct OriginAdm1Id)=1, OriginLocationCode)&

' - '&

if(count(total distinct DestinationCountry)>1, DestinationCountry) &

if(count(total distinct DestinationCountry)=1 and count(total distinct DestinationAdm1Id)>1, DestinationAdm1Id) &

if(count(total distinct DestinationCountry)=1 and count(total distinct DestinationAdm1Id)=1, DestinationLocationCode)

And then use measures for start and end like this:

if(count(total distinct OriginCountry)>1, OriginCountryCoordinates) &

if(count(total distinct OriginCountry)=1 and count(total distinct OriginAdm1Id)>1, OriginAdm1Coordinates) &

if(count(total distinct OriginCountry)=1 and count(total distinct OriginAdm1Id)=1, OriginLocationCoordinates)

Thanks,

Patric Nordström

Qlik

[Anonymous]

Thank you bps that really helps i cant thank you enough for directing me. I have few more issues in this.

When i doing drill down it is not working fine. Please see attached QVF file. Also i have few questions

Can we do below things:

Sheet name is Drilldown sheet where i did all this.

1.placing origin arrow start color different with that of destination end  points

different color.

2. Landing page of the map is leaving more space how can we avoid that. if you want i can send you screen shot

2. Area layer is not working properly if i dd in the same sheet and map. Do you think we should not do that.

3. Looks like in my data some of the country related data is not good how can i get the right mapping. for example in USA is listed as US or United states does geoanalytics directly recognizes. if there is any doc please provide.

4. Last thing is can i create my own custom dimension like a Region which combines 3 to 4 countries together and use it . Does geoanalytics recongnizes.If so how can i do it is there any documentation.

Thanks for all your help

mto

[Patric_Nordstrom]

Responding in thread:

https://community.qlik.com/message/1266374?et=watches.email.thread#1266374