Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Working with a Risk Map

Hello everyone,

I have a requirement to build a Risk Map, and i am not sure if it is possible to build something similar in QlikView, see below:

Capturar.PNG

The data base is a spreadsheet and the IMPACT (X axis) is a column and the LIKELIHOOD (Y axis) is other column. I know i can use both columns as a dimension to build the chart, but i don´t know what type of chart i can use to build something similar. The yellow squares represents the low risks, orange squares represtens Medium risks, and red squares represents the High Risks.

The Numbers inside the squares represents where the Risk is qualified.

Anyone built something similar in QlikView? Tips?

Regards!!

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe one solution could be a pivot table with background colours:

QlikCommunity_Thread_220796_Pic1.JPG

QlikCommunity_Thread_220796_Pic3.JPG

QlikCommunity_Thread_220796_Pic4.JPG

QlikCommunity_Thread_220796_Pic5.JPG

tabRiskColours:

LOAD Dual(Risk,AutoNumber(Risk,'Risk')) as Risk,

    RGB(R,G,B) as RiskColour

Inline [

Risk,R,G,B

Very High,255,  0,  0

High     ,255,153, 51

Medium   ,255,204,  0

Low      ,255,255,153

];

tabTemp:

LOAD Dual(Likelihood,AutoNumber(Likelihood,'Likelihood')) as Likelihood,

    Dual(Impact,AutoNumber(Impact,'Impact')) as Impact

Inline [

Likelihood,Impact

Very High,Very High

High,High

Medium High,Medium High

Medium Low,Medium Low

Low,Low

Very Low,Very Low

];

tabLikImpRisk:

LOAD *,

    AutoNumber(Likelihood&'/'&Impact,'LikImp') as %LikImpKey

Inline [

Likelihood,Impact,Risk

1,1,1

1,2,1

1,3,1

1,4,2

1,5,3

1,6,3

2,1,1

2,2,1

2,3,2

2,4,2

2,5,3

2,6,4

3,1,1

3,2,1

3,3,2

3,4,2

3,5,3

3,6,4

4,1,1

4,2,2

4,3,2

4,4,3

4,5,3

4,6,4

5,1,1

5,2,2

5,3,3

5,4,3

5,5,4

5,6,4

6,1,2

6,2,2

6,3,3

6,4,3

6,5,4

6,6,4

];

DROP Table tabTemp;

tabRisks:

LOAD RecNo() as RiskID,

    AutoNumber(Likelihood&'/'&Impact,'LikImp') as %LikImpKey

Inline [

Likelihood,Impact

3,4

4,6

5,2

4,3

4,3

4,4

5,4

5,4

5,4

5,4

5,4

2,5

4,5

4,5

4,5

];

hope this helps

regards

Marco

View solution in original post

15 Replies
Anonymous
Not applicable
Author

Hi Rogrigo,

I think that you can do it with a Scatter Chart, I don't know any Extension like this or similar.

Your risk colours and zones may be an image, and you need to locate your tasks with calculations.

Regards!

Not applicable
Author

Hi Manuel!!

Thanks for your suggestion!

Do you have or know where i can find a sample example to apply that solution?

I have no idea how to use an image into a Scatter Chart.

Regards!

MarcoWedel

Hi,

maybe one solution could be a pivot table with background colours:

QlikCommunity_Thread_220796_Pic1.JPG

QlikCommunity_Thread_220796_Pic3.JPG

QlikCommunity_Thread_220796_Pic4.JPG

QlikCommunity_Thread_220796_Pic5.JPG

tabRiskColours:

LOAD Dual(Risk,AutoNumber(Risk,'Risk')) as Risk,

    RGB(R,G,B) as RiskColour

Inline [

Risk,R,G,B

Very High,255,  0,  0

High     ,255,153, 51

Medium   ,255,204,  0

Low      ,255,255,153

];

tabTemp:

LOAD Dual(Likelihood,AutoNumber(Likelihood,'Likelihood')) as Likelihood,

    Dual(Impact,AutoNumber(Impact,'Impact')) as Impact

Inline [

Likelihood,Impact

Very High,Very High

High,High

Medium High,Medium High

Medium Low,Medium Low

Low,Low

Very Low,Very Low

];

tabLikImpRisk:

LOAD *,

    AutoNumber(Likelihood&'/'&Impact,'LikImp') as %LikImpKey

Inline [

Likelihood,Impact,Risk

1,1,1

1,2,1

1,3,1

1,4,2

1,5,3

1,6,3

2,1,1

2,2,1

2,3,2

2,4,2

2,5,3

2,6,4

3,1,1

3,2,1

3,3,2

3,4,2

3,5,3

3,6,4

4,1,1

4,2,2

4,3,2

4,4,3

4,5,3

4,6,4

5,1,1

5,2,2

5,3,3

5,4,3

5,5,4

5,6,4

6,1,2

6,2,2

6,3,3

6,4,3

6,5,4

6,6,4

];

DROP Table tabTemp;

tabRisks:

LOAD RecNo() as RiskID,

    AutoNumber(Likelihood&'/'&Impact,'LikImp') as %LikImpKey

Inline [

Likelihood,Impact

3,4

4,6

5,2

4,3

4,3

4,4

5,4

5,4

5,4

5,4

5,4

2,5

4,5

4,5

4,5

];

hope this helps

regards

Marco

Anonymous
Not applicable
Author

Hi Rodrigo,

Like google maps: Step-by-Step Google Map API v3 integration

Regards!

Not applicable
Author

Hi Marco,

Thats a very interesting solution! Thank you very much for your contribution.

One of the requeriments suggests a Risk table like that, which displays the position of the Risk on the Map, when one of the risk is selected in the filter, something like that:

Sem título.png

In the solution you proposed, when i select a Risk in the filter, the table is resized:

Capturar.PNG

It displays the correct position, but i would need to display the entire table, with only the value selected in the filter, in that case Risk 7.

Can you imagine a solution for that?

I tryied to find something in the table properties, but i was not able to do something similar to the requirement.

Thanks

Thank you

jim_chan
Specialist
Specialist

it is a pivot table, by nature, when you have selected a column in pivot table, it wil only display that specified column.

MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_220796_Pic6.JPG

QlikCommunity_Thread_220796_Pic7.JPG

hope this helps

regards

Marco

jim_chan
Specialist
Specialist

ok thanks Marco!

vikasmahajan

Very Nice Visualization Macro !!!

Thanks you sharing

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.