Creating Cross tab by modifing expression

saurabh5 — Fri, 19 Jun 2015 02:09:40 GMT

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 !

Re: Creating Cross tab

qlikviewwizard — Fri, 19 Jun 2015 02:29:37 GMT

Hi saurabh5,

Please watch/or check this:

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

topic Re: Creating Cross tab in QlikView

Creating Cross tab by modifing expression

Re: Creating Cross tab