Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hi saurabh5,
Please watch/or check this:
Power of Qlik Script - Reshaping Data with Crosstable (video)