CrossTable with multiple columns

[priya945]

HI All,

Could someone help to load  below cross table data into qlikview

Case Number	Region	Value1	Value2	Closed Date	Opened Date	30-08-2018	31-10-2018	30-09-2018
1234	North	1	1	30-08-2018	30-08-2018	1	1	1
1243	North	0	1	30-09-2018	30-09-2018	0	1	0
1245	South	1	0	31-10-2018	31-10-2018	1	0	0
1254	South	1	1	30-08-2018	30-08-2018	0	1	1
1123	East	0	0	30-09-2018	31-10-2018	1	0	0
1232	West	0	1	31-10-2018	31-10-2018	1	1	1

Thanks in advance

[Brett_Bleess]

Priya, have a look at the following Design Blog post, believe this should likely help you get the job done:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

Regards,
Brett