Creating Cross tab by modifing expression

[saurabh5]

hi all,
i am trying to create a cross tab with 'orgnaization' and 'owner' as dimension and measure is avg of 'rank' by distinct count of unique id created.

but the avg values needs to be compared by a rank bracket weight table provided by user

severity    rank bracket
Very High   12-16
High        6-11.99
Moderate    3-5.99
Low         0-2.99

the script which i have till now :

Test:

LOAD * INLINE [
Region, Country, Organization, rank, owner
1, A, East, 2, peter
2, B, West, 4, Sam
3, C, NorthEast, 8, Alex
4, D, WestCost, 12, Wallen
5, E, North, 8, Dona
6, F, South, 2, Ben
7, G, SouthWest, 2, Tina
8, H, South, 4, Ben
9, I, West, 8, Sid
10, J, WestCost, 8, Wallen
];

Test2:
NoConcatenate
load * ,
Region&'-'&Country as UniqueID
Resident Test;

drop Table Test;

so the output should look like the attachment

Thanks for the help in advance !

[qlikviewwizard]

Hi saurabh5,

Please watch/or check this:

Power of Qlik Script - Reshaping Data with Crosstable (video)