19 Replies Latest reply: Sep 20, 2017 8:57 AM by pradosh thakur RSS

    show last 24 hours only - Qlik sense

    Joanna Seldon


      Hi

       

      looking to find how I can use set analysis to only show the last 24 hours of activity

       

      dimension is OrderDateHour

       

      example

       

      01/01/2001 01:00:00

      01/01/2001 02:00:00

      01/01/2001 03:00:00

       

      I have to this split into separate fields as OrderDate and OrderHour

       

      I have found code that takes away the last 24 hours, but that's not what I am  looking to do

       

      any ideas please

       

      Kind Regards