topic Re: Help me on creating flags with range(LOW/MEDIUM/HIGH) in QlikView

Help me on creating flags with range(LOW/MEDIUM/HIGH)

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

Hi Experts ,

Need your help on below Data flagging range(LOW/MEDIUM/HIGH)

Data i have as input :

Tab 1:

LOAD * INLINE [

Country

OTHER

"OTHER,INDIA"

USA

"UK,INDIA"

INDIA

"INDIA,USA"

BLANK

];

Types of Priority_risk as need:

INDIA--->LOW

UK------>MEDIUM

USA----->HIGH

OTHER--->HIGH

BLANK--->LOW

Expected output:

OTHER-------->HIGH

OTHER,INDIA-->HIGH

USA---------->HIGH

UK----------->MEDIUM

UK,INDIA----->MEDIUM

INDIA-------->LOW

INDIA,USA---->HIGH

BLANK-------->LOW

Note: If Priority_risk > 1 value (i.e some times country have more than one priority)THEN use the one with the highest risk

Ex:-(OTHER,INDIA-->HIGH).

Thanks,

Suresh V.V

Re: Help me on creating flags with range(LOW/MEDIUM/HIGH)

Sergey_Shuklin — Fri, 03 Nov 2017 08:35:38 GMT

Hello!

You can use Index() function for searching some text within the string.

And you should use risk numeric indication, like 0 - low, 1 - medium, 2 - high. And after that you can pick the highest risk status using max() function and grouping.

Re: Help me on creating flags with range(LOW/MEDIUM/HIGH)

antoniotiman — Fri, 03 Nov 2017 08:52:22 GMT

May be this

MapTable:
Mapping
LOAD * Inline [
A,B
INDIA,1
UK,2
USA,3
OTHER,3
BLANK,1];

LOAD * Inline [
Priority,Risk
1,LOW
2,MEDIUM
3,HIGH];

Tab1:
LOAD Country,Max(Priority1) as Priority Group By Country;
LOAD Country,SubField(Priority,',') as Priority1,Priority;
LOAD *,MapSubString('MapTable',Country) as Priority INLINE [
Country
OTHER
"OTHER,INDIA"
USA
UK
"UK,INDIA"
INDIA
"INDIA,USA"
BLANK];

Re: Help me on creating flags with range(LOW/MEDIUM/HIGH)

Mark_Little — Fri, 03 Nov 2017 09:04:37 GMT

Hi,

Take a look at the attached app.

Mark

Re: Help me on creating flags with range(LOW/MEDIUM/HIGH)

venkatasuresh — Fri, 10 Nov 2017 08:58:05 GMT

Thank You all for your valuble time

Thanks,

Suresh V.V