topic Re: QlikSense multiple dates as a expression e.g. last 6 months? in App Development

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

Anonymous — Thu, 26 Jul 2018 19:32:09 GMT

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?

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

Anonymous — Thu, 26 Jul 2018 21:31:17 GMT

Chart expression - closed dates

my question is very similar to this one.. but hoping to implement the solution

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

Anonymous — Thu, 26 Jul 2018 22:06:31 GMT

solved via this (based off the thread above) Chart expression - closed dates

I realized this can be done by just appending to the code section rather than unlocking.

It is a new table , which is a drawback in a way I guess, but it works well !

RequestsTimeLine_QueueRate:

LOAD

[request] AS [Slide70_RequestClosed.request],

    [request.opened_at] as Date,

        'created' as DateType,

        1 as CreatedCount

FROM [lib://Report Automation/ITSM Process Slides-May2018-Elton_vChg - massive before pivotredo.xlsx]

(ooxml, embedded labels, table is Slide70_RequestClosed);

Concatenate(RequestsTimeLine_QueueRate)

LOAD

[request] AS [Slide70_RequestClosed.request],

    [request.closed_at] as Date,

        'closed' as DateType,

        1 as ClosedCount

FROM [lib://Report Automation/ITSM Process Slides-May2018-Elton_vChg - massive before pivotredo.xlsx]

(ooxml, embedded labels, table is Slide70_RequestClosed);