2 Replies Latest reply: Jul 26, 2018 6:06 PM by Elton Aguiar RSS

    QlikSense multiple dates as a expression e.g. last 6 months?

    Elton Aguiar

      Hi,

      I've been trying to get closed and open tickets in a month in the same table so I can calculate a queue rate of # of closed tickets versus opened by month.

      Using "autocalendar" of either opened or closed tickets seems to give the wrong data unless the date is a manual calculation like this

       

      =monthstart(today()-80) //this is great... and returns 2018-05-01(may) ..

       

      but now I need multiple dates not just 1 . as you see in the pivot only 1 column is generated with the formula above .. but I want a range of dates instead of a single date. Is it possible?

      I was hoping to do it via expression .. something like last 6 months dates from today for example?

       

      pivotdatesissue.png