CrossTable with multiple columns

priya945 · ‎2020-01-08

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 · ‎2020-02-05

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

General Question

Related Topics