topic Re: can scatter chart applied on a static image? in QlikView

can scatter chart applied on a static image?

Tue, 11 Oct 2011 03:37:29 GMT

Hi All:

i want to apply a scatter chart on an image, it that possible? The detailed requirement is as following:

" i want to prepare a demo for real estate industry, and need to apply a scatter chart on aerial view of each project, the bubble will indicates if there is Residential or Hotel or Office, and when click the bubble , there will be a form displayed describe the detailed info of this building"

Can this requirement be achieved in QV? Really appreciate if anyone can give me some comments. Thanks all

Thanks

Stefanie

can scatter chart applied on a static image?

vincent_ardiet — Tue, 11 Oct 2011 07:45:09 GMT

Hi Stefanie,

Yes, you can use an image, in the properties of your chart, on the "colors" tab you can specify a static or a dynamic image.

If you want that details appear when you choose a building, you can use in the "layout" tab, a conditional expression to hide or not your sheet objects. For example, if you want that an object is visible when a single value is selected in a dimension named "Dim1", you can use : if(Only(Dim1)=Dim1,1,0).

Regards,

Vincent

can scatter chart applied on a static image?

Tue, 11 Oct 2011 08:42:51 GMT

Hi Vincent, thanks for your comments. But i'm wondering how to decide the coordinate of the bubble?? because i should decide which site would be placed with "Residential", which would be palced with" Hotel", etc

can scatter chart applied on a static image?

vincent_ardiet — Tue, 11 Oct 2011 09:04:20 GMT

You will have to store the coordinates of your site in a table.

For example, open your image with mspaint, look at the coordinates of your different sites and make an excel files with them.

Then on QV, force the scale of you scater chart in order to match the exact size of your picture.

can scatter chart applied on a static image?

Tue, 11 Oct 2011 14:34:35 GMT

OK. Besides the coordinates, if there any requirement for the Axis (static min and static max?), and if there need to load any scripts in the "main" sheet?

Re: can scatter chart applied on a static image?

Tue, 11 Oct 2011 14:55:51 GMT

Hi Vincent, i have tried this function by your comments, but there is some problems with it. FIrst, the expression of "Long" and "Height" of the image is not sure. at first, i just use [Long] and [Height] as the expression, but it says the express is too few, then i use sum to express, but the coordinate is not i want. Can you help me to figure out this problems. I would love to upload the doc i used, please refer to the attachment

Re: can scatter chart applied on a static image?

vincent_ardiet — Tue, 11 Oct 2011 15:08:18 GMT

Here is an example, I will have a look to your application.

Re: can scatter chart applied on a static image?

Tue, 11 Oct 2011 15:11:13 GMT

Many Thanks, Vincent. So, the dimension in your sample is X and Y, not the Contry Name?

Re: can scatter chart applied on a static image?

vincent_ardiet — Tue, 11 Oct 2011 15:19:50 GMT

Yes that's it.

The country is just used to join the sales figures and the coordinate.

Re: can scatter chart applied on a static image?

Tue, 11 Oct 2011 15:46:27 GMT

But, when the moust move on the bubble, i want displayed Project name instead of the value of X and Y, can it be achieved? and i also want the label on the right hand side to show project name, not the X,Y

Re: can scatter chart applied on a static image?

vincent_ardiet — Wed, 12 Oct 2011 08:18:49 GMT

Hi Stefanie,

In order to show the project name in the popup :

- Disable "Pop-up labels" in the "Presentation" propertie tab of the chart;

- In the "Expressions" tab, choose the advanced mode and create a new expression defined with Country ([Type(Image)] in your application);

- Check the "Text as Pop-up" display options for this expression;

- Uncheck "Expressions as Legend" for each expression.

But, I don't know if it is possible to have the label of your projects (my countries) on the right. I have not managed to do this.

can scatter chart applied on a static image?

Tue, 14 Feb 2012 13:09:28 GMT

Hi Vincent,

I tried to use the kind of map you created in my report because i am totally new to maps in qlikview thing..

But I dont catch it why you have latitudes / longitudes in some other format. can you help with explaining that?

For my map I loaded the list of countries with longitudes and latitudes.. so E.g. Russia is 60, 100. However, when i try to calculate sums per country - the bubbles land all in the lower left corner - as in your map E.g. Russia is 856, 633.

I need the countries all over the world on my map so can you suggest if i should load some different-format coordinates for them or recalculate somehow to get the correct picture?

Many thanks in advance for help

justyna

can scatter chart applied on a static image?

vincent_ardiet — Wed, 15 Feb 2012 07:59:29 GMT

Hi,

The solution I've proposed is based on a static image and not on a dynamic map (like using gmaps or geoqlik).

So, coordinates are not latitudes and longitudes but the position of the point in the image. You have to use for example mspaint in order to find the coordinate in the image.

Regards,

Vincent

can scatter chart applied on a static image?

Wed, 15 Feb 2012 08:01:21 GMT

Meanwhile I found it out too. Thanks anyway for the reply:)

Justyna

can scatter chart applied on a static image?

amien — Mon, 26 Mar 2012 21:39:20 GMT

briljant .. thanks!

can scatter chart applied on a static image?

Wed, 11 Apr 2012 09:41:51 GMT

Hello ,
when you open the file in mspaint, how can you look up at the coordinates of the different files?

Thanks

Nicolas

Re: can scatter chart applied on a static image?

Anonymous — Wed, 11 Apr 2012 10:01:34 GMT

Hi Nicolas,

When you move over the picture with your mouse the coordinates are in the lower bar.

Good Luck,

Dennis.

can scatter chart applied on a static image?

Wed, 11 Apr 2012 10:07:15 GMT

Thanks Dennis

Re: can scatter chart applied on a static image?

Tue, 11 Feb 2014 04:11:19 GMT

Hi Mate,

I create a simple app. This app has shown sales per state in scatter chart with australia map as backgroud. It may help you. regards, jon