topic Re: Stores Performance Map? in QlikView

Stores Performance Map?

tomovangel — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,
I have got a map, ( which is an image .png)

And it shows me how the Mall is structured, and all the corresponding shops.
IF i make a Random generator for stores from 1001 to 1063( the stores in the map)
and then I make a Random generator for Sales of stores from 1001 to 1063,
How to show how much sales each store has, on the map?

-Thanks

Re: Stores Performance Map?

swuehl — Mon, 18 Sep 2017 13:01:52 GMT

You could use this image as a background image in a scatter chart, create your own coordinate system that links image positions to stores and use stores as dimension and your coordinates as x/y expressions.

You can use an expression for z (bubble size) to indicate your sales.

There are some examples here that show how to do that, search for 'google maps' or similar here in the forum.

Re: Stores Performance Map?

marcus_sommer — Mon, 18 Sep 2017 14:48:34 GMT

I have seen something like this a few years ago by a presentation from the qlik partner Transact with the tool QlikMap which is based on Openstreetmap:

Transact erweitert QlikView mit dem neuen Modul QlikMap 4.1 um die räumliche Dimension

- Marcus

Re: Stores Performance Map?

tomovangel — Mon, 18 Sep 2017 14:59:40 GMT

this is what I made,
I loaded the Mall map, and i made Points for every store,
Now I have to fill data for every store

Re: Stores Performance Map?

swuehl — Mon, 18 Sep 2017 15:18:54 GMT

Maybe like

LOAD

Recno()+1000 as StoreID,

Ceil(RAND()*10000) as Revenue

Autogenerate 63;

Re: Stores Performance Map?

marcus_sommer — Mon, 18 Sep 2017 15:21:14 GMT

It looked already quite good. If you follow the suggestion from Stefan and adjusting the size and maybe the color of the bubbles you should get the information which you want. Further if you could faint a bit the color of the map it would increase the readability of the bubbles.

- Marcus

Re: Stores Performance Map?

tomovangel — Tue, 19 Sep 2017 06:16:58 GMT

Yep, Thanks 🙂
This is exactly what I was looking for .
Now do you think it's possible if I reload the application, Make a Table box with StoreId and Revenue - Export it to excel, and then repeat the same 12 times, to get the values for 12 months?

Re: Stores Performance Map?

tomovangel — Tue, 19 Sep 2017 06:17:09 GMT

Thanks

Re: Stores Performance Map?

swuehl — Tue, 19 Sep 2017 07:40:13 GMT

Theoretically, yes, it's possible, but it's much easier to do it in the script, like

LOAD *,

Ceil(RAND()*10000) as Revenue,

Monthname(Makedate(2016,iterno())) as YearMonth

While iterno() <=12;

LOAD

Recno()+1000 as StoreID

Autogenerate 63;

Re: Stores Performance Map?

tomovangel — Tue, 19 Sep 2017 07:41:41 GMT

Thanks, This is way more useful

Re: Stores Performance Map?

tomovangel — Tue, 19 Sep 2017 12:10:49 GMT

Hello Stefan,
I have been wondering, Is it possible to choose which labels are showing, when the User hoovers up over the points.
Now it shows
Store:
Latitude:
Longitude:

Net Amount:

Can I make it to show only
Store:
Net Amount:
?
- Thanks

Re: Stores Performance Map?

swuehl — Tue, 19 Sep 2017 12:38:40 GMT

You can disable 'pop-up labels' on presentation tab, create a 4th expression (in advanced mode) like

='Store: ' &StoreID & chr(13) & 'Net Amount: '&Sum(Revenue)

and enable 'Text as pop-up' option for that expression only on expression tab

Re: Stores Performance Map?

tomovangel — Tue, 19 Sep 2017 12:41:04 GMT

Thanks for the help with everything
I wish you a great week

Re: Stores Performance Map?

Colin-Albert — Tue, 19 Sep 2017 12:50:11 GMT

Anther option is to use a custom SVG map with the SVG Map extension object.

GitHub - brianwmunz/svgReader-QV11: Repository for storing the code for the svgMap extension for QlikView 11.