Thursday, April 28, 2016

How to create Metro map in Qlikview?

Metro chart is the advances implementation of existing Scattered chart in qlikview, which does look like as below.




We can understand it with below example..

to implement Metro chart we need one metro image already created at back end to implement the chart. Then we will create one inline table or can use existing data from backend.


LOAD * INLINE [
    ACTIVITY_ID, X, Y
    1, 0.1, 13
    2, 0.1, 8.7
    3, 1.5, 15.7
    4, 1.5, 11.2
    5, 1.5, 6.4
    6, 1.5, 1.5
    7, 2.2, 1.5
    8, 3.7, 11.2
    9, 4.3, 11.2
    10 ,5.4, 9
    11 ,5.4, 13.6
    12 ,6.1, 9
    13, 6.6, 9
    14, 7.2, 9
    15, 7.8, 9
];


Steps
1. Goto the create chart, select scattered chart.
2. Select the dimension(Action ID).
3. Expression tab, select X and Y as expression and create one more expression SUM(Action ID).
4, Goto to the color tab, select Frame background image and save it.


you can play with other existing options to make the chart more attractive.
please follow the above steps and get the desired chart.

cheers
shiv