Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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);

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Chart expression - closed dates

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

Anonymous
Not applicable
Author

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);