5 Replies Latest reply: May 30, 2018 6:59 PM by David Forest RSS

    Dates from excel

    Del Booth

      Hi

      I am trying to only sum dates for a gauge chart that are for the year 2018, the column of data has data from 2016 to 2018.  The data format is 04/03/2018  00:00:00.  Do I need to reformat the data or can Qlik view identify the year and use that in the sum expression.

       

      Thnaks