10 Replies Latest reply: Nov 27, 2015 4:13 AM by Jim Chan RSS

    Excel Template with crosstable function?

    Jim Chan

      Hi there,

       

      client wanted to use back the current excel template and input all these info into qlikview, rather than recreating a new data structure format. I heard of crosstable function ? or could find a solution in 'Transformation'?

       

      In the end, of cos i would like to create a dimension from the excel template, without askign my client to change anything from the current template - such as, School dimension(School A - School J), Calendar - (Year & Month).

       

      I have attached the excel template as well.

      student_attendance.jpg