9 Replies Latest reply: Oct 10, 2017 5:31 AM by sahadev patil RSS

    remove 00:00:00 time from a chart qlik sense

    Joanna Seldon

      Hi

       

      I have a trend graph line..and these values show as time differences for orders per customers

       

      This is the sort of question to ask how to stop showing 0 however

       

      This measure is worked out using an if statement.. within the if statement there is sum difference  between two time stamps.

       

      if("CheckDate" < StartCheckDate , max({$<[Temperature]={'<=0'}>} CheckDate) - min({$<[Temperature]={'>0'}, CheckNumber = {1}>} CheckDate), max({$<[Temperature]={'<=0'}>} CheckDate) - min({$<[Temperature]={'>0'}, CheckNumber = {2}>} CheckDate))

       

      1. However some customers are showing up as 00:00:00 how do I in the measure say don't show these customers.. that have 00:00:00 after the calculation ?

       

      or 2. is there a way under the limitation section of qlik to remove 00:00:00 time as more than value?

       

      CheckDate, StartCheckDate, all are formatted 01/01/2001 00:00:00   

       

      CheckNumber just increment numbers as 1, 2, 3

       

      cant send sample of data sorry

       

      please help..