topic Re: OpenLayers mapping - containter boxes causing strange placement of map in QlikView

OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 10:06:42 GMT

Hi all,

I am mapping some information on a map of the UK and want to compare multiple versions of the mapped info using side by size container boxes. I have this strange occurance that when I try and do this, the immage from the seccond container box sits outside of the container and instead is located benieth the 1st container. The below picture will descibe what I mean. Does anyone know how I can fix this issue? (Please bear in mind my QlikView skills are not yet very advanced - I did not write the code the mapping - this was done by a colleauge).

Many thanks,

Isabel

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 10:11:33 GMT

Try to use the tab mode within the container.

If still find rendering issues, don't use the container and place two different objects and some text objects or buttons to show / hide a specific map.

Or, just place the two maps side by side.

If you have many metrics, you can use one map and use a dynamic measure (with a variable) so you won't need many map objects.

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 10:22:18 GMT

Hi Borja,

There does not seem to be a "Mode" tab in the container box properties. I think that both solutions would work, the first would be easy for me to do, but I would like to get it working with variables. Could you point me to somewhere where I can learn how to create variables?

For this work, I will have a selection of measures under which I will rank 152 areas on England. It is this rank that then determines the collouring. i.e. in the map: if(rank(sum(total<[AREA#]> MEASURE))<=50,rgb(44,27,69), ....

Could you suggest how I set it up such that the measure is a variable?

Thank you,

Isabel

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 10:40:36 GMT

I'm sorry I wasn't clear about the tab mode.

I was referring to the "Single Object" mode in the Container:

About using variables, you can create/manage document variables using the Variable Overview panel (Ctrl+Alt+V) or in the Variables tab within the Document Properties section.

Create a variable vExpression using:

=only(Expression)

where Expression is the field containing the "label" of the expression and Formula is a field with the associated value to Expression which contains the expression to use in the chart.

Then, in the extension, use:

$(=vExpression)

Hope it helps.

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 10:59:29 GMT

Looked easy, but I am obviously not quite there.... I have set up one variable as shown below in the screen shot, and then in the mapping extension I have written "if($(=vEngagement_Rank)<=50,rgb(44,27,69)..." but this does not seem to register any collours.... I tried taking the "only" out and this gave me a different, quite wrong picture of everything colloured in rather than none or even the correct shading which I have already in the above post .

Any further tips? Also, how will I get the map to change from this variable, to another without creating a new graph?

Thanks for your help,

Isabel

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 11:04:46 GMT

You are missing one step Isabel, creating the Formula field with the formula.

I created it with an inline table in the script, as follows:

LOAD * INLINE [

Expresssion, Formula

Expression A, "Index(Municipi,'e')"

Expression B, len(Municipi)

];

And the variable vExpression contains

=only(Formula)

You cannot replace your formula inside the ONLY function in the variable because it won't work, it is not the same thing.

Try to replicate the variables table above or, in vExpression use:

=rank(.... Hours)

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 11:17:06 GMT

I realise that I am taking this as verbatim, but the script looks unhappy:

LOAD

* INLINE [

    Expresssion, Formula

    Expression_Eng_Rank, rank(sum(total<[LA No]> [Hours])),

    Expression_TBC_Count, count(distinct [LA No])

    ];

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 11:20:46 GMT

When using Inline tables, enclose the values between double quotes when using special characters:

LOAD * INLINE [

    Expresssion, Formula

    Expression_Eng_Rank, "rank(sum(total<[LA No]> [Hours]))"

    Expression_TBC_Count, "count(distinct [LA No])"

    ];

Take a look at my inline table:

LOAD * INLINE [

Expresssion, Formula

Expression A, "Index(Municipi,'e')"

Expression B, len(Municipi)

];

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 11:26:21 GMT

Yes, I tried this too, but it still does not accept it in the script. Maybe the script is unable to do the formula I am using (?) but I know the formula works properly in the orignical chart which seems strange to me.

LOAD

* INLINE [

    Expresssion, Formula

    Expression_Eng_Rank, "rank(sum(total<[LA No]> [Hours]))"

    Expression_TBC_Count, "count(distinct [LA No])"

    ];

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 13:47:01 GMT

I see. I tried it and also get the error too, due to the [] characters I think.

Ok, different approach, try to load from an xls file (or csv, etc.). Like the attached file.

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 14:11:57 GMT

Ok, so I have uploaded that file into the script, but I only put the first expression in as I this may make it easier to check if it's beginning to work.... and hurar, it does! Thank you for your patience here, this is a great help and I'm certainly picking up some good tips.

So the final part is how do I set this us so that I can select Expression1,2,3... from something like a drop-down menu? I am imagining having two maps side by side, and being able to select the expression to be mapped on each one.

Thanks,
Isabel

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 14:20:11 GMT

If you want to have to listboxes, one for each map and show both maps, then load the table twice with different names and create two variables. Same way.

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 14:24:46 GMT

Ok, that makes sense. So even on one map, how to I set up up so that I can select which variable to plot?

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 14:28:13 GMT

I showed it in the 2nd screenshot of the above post.

Listbox with the Expression field.

Variable vExpression containing "=only(Formula)"

Map using $(=vExpression) in the meausre (or Opacity Expression depending on the extension you are using) property.

Re: OpenLayers mapping - containter boxes causing strange placement of map

Tue, 14 May 2013 14:32:29 GMT

I had completely missed that point before! Thank you so much for you patience - this solution works just great!

Re: OpenLayers mapping - containter boxes causing strange placement of map

Thu, 16 May 2013 19:30:14 GMT

Hi agian,

I am trying to put set analysis in the Formula (in my Expression and Formula table in Excel) but it does not display the right shading in QlikView. Do you have any suggestions as to how to get that to work?

Thanks,

Isabel