3 Replies Latest reply: May 17, 2018 4:38 PM by Leandro Amorim Carisio RSS

    Please, help! I can't select and subtract days from max(date)

    Leandro Amorim Carisio

      Hello, please I would like some help with a problem using qlik sense.

       

      I need to limit the data in a graphic to the last 14 days. I am trying to use the following expression in the dimension field:

       

      =IF(DATE(CRESCIMENTO_BANCO_COMPLETO.DATA)>=DATE(MAX(CRESCIMENTO_BANCO_COMPLETO.DATA)-14),CRESCIMENTO_BANCO_COMPLETO.DATA)

       

      If I use just

       

      =CRESCIMENTO_BANCO_COMPLETO.DATA

       

      The graphic plots ok, but with all data.

       

      Thank you very much!