Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomovangel
Partner - Specialist
Partner - Specialist

Stores Performance Map?

Hello guys,
I have got a map, ( which is an image .png) g1.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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

13 Replies
swuehl
MVP
MVP

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.

marcus_sommer

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

tomovangel
Partner - Specialist
Partner - Specialist
Author

Screenshot_1.png

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

swuehl
MVP
MVP

Maybe like

LOAD

     Recno()+1000 as StoreID,

     Ceil(RAND()*10000) as Revenue

Autogenerate 63;

marcus_sommer

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

tomovangel
Partner - Specialist
Partner - Specialist
Author

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?

tomovangel
Partner - Specialist
Partner - Specialist
Author

Thanks

swuehl
MVP
MVP

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;

tomovangel
Partner - Specialist
Partner - Specialist
Author

Thanks, This is way more useful