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

    create new field in load clause with minus

    laicong zhang

      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:

       

      LOAD

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

      [Last day]

      from

      xxxxxx

       

       

      Could you please help me on this issue?

      Many thanks and thanks in advance!

      br,

      lisen