3 Replies Latest reply: May 17, 2017 12:39 PM by victor daniel rojas RSS

    How to show only last 7 days rows Qlik Sense Table

    Gabriel Belini

      Hi, I have a table that looks like the one below:

       

      fotoHG.png

       

      I would like to show only rows from the last 7 days based on the field "FINALDATE".

      For example: if (finalDate >= date(now()-7), showRow)

       

      All columns were created as dimensions, I dont want my user to have to select a filter for last week Operations, I want him to be able to see only the rows from the last 7 days without having to touch anything.