7 Replies Latest reply: Jan 22, 2015 7:51 AM by jagan mohan rao appala RSS

    create new field in load clause with minus

      Hi ,

      I want to create a new field in Load clause which is named [Last day]. And this is calculated by the two existed field in the same load clause [submit date] & [Last modified date].

      I think i find another problem, can qlikview make minus operation just on the date? If below two types date is captured with left() function i think the minus operation cannot be done. So how can i calculate the duration between submit and last modified?


      So I programmed the script like this:



      [Last Modified Date],
      [Submit Date],
      ([Last Modified Date] - [Submit Date]) as

      [Last day]





      Could you please help me on this issue?

      Many thanks and thanks in advance!