5 Replies Latest reply: Jul 15, 2015 6:33 AM by Prashant Baste RSS

    How to load excel data dynamically into QlikView?

    Uday P

      Hi There,

      I have a requirement where in I have to convert the received excel data into custom format and then use it in qlikview. This I had to do every year. For this purpose I want to create a qvw file which fulfills the process automatically by taking the excel data every year.  Can anyone please help me. For example, the data received is as follows

      Date     Working Day     Date     Working Day

      1/1/2013     0               1/1/2014     0

      2/1/2013     1               2/1/2014     0

      3/1/2013     1               3/1/2014     1

      .

      .

      .

      .

      .

      .

      31/12/2013     0               31/12/2014     0

       

      Custom Format to which it has to be converted automatically

      Date     Working Day

      1/1/2013     0           

      2/1/2013     1           

      3/1/2013     1           

      .

      .

      .

      .

      .

      .

      31/12/2013  0       

      1/1/2014     0

      2/1/2014     0

      3/1/2014     1

      .

      .

      .

      .

      .

      31/12/2014     0