Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to transfer this data with below view on Qlik dashboard?
Hi
below the logic step by step
1 : load data as it is
2 : replicate field Region when missing
3 : croostable data
4 create new fied for Globa et South named Type_Region and create subfield Type for A B C .
:
LOAD * INLINE
[
Region,Country,A_Global,B_Global,C_Global,A_South,B_South,C_South
Asia,India,12,42,12,10,9,8
,Srilanka,12,32,12,23,3,5
,Japan,12,1,43,23,22,12
](delimiter is ',');
NoConcatenate
Table1:
load
if(len(Region)>0,Region,peek('Region')) as Region,
Country , A_Global,B_Global,C_Global,A_South,B_South,C_South
resident Table; drop table Table;
Table2:
crosstable ( Type,Amount,2)
load* resident Table1; drop table Table1;
noconcatenate
Table3:
load
Region,
Country,
subfield(Type,'_',1) as Type,
subfield(Type,'_',2) as Type_Region,
Amount
resident Table2 ; drop table Table2;
Resulting Table :
hope it helps