Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filtering multiple date values in Qlik Sense

Hi

I have a question concerning filtering multiple data values in Qlik Sense.

I'm working on a Helpdesk Performance Reporting, based on a OTRS database. I access the database via SQL Linked Servers. In my table i have all the details of my helpdesk cases such as ticket id, CreateDate (eg. 01.02.2016) and CloseDate (eg. 31.01.2016). Based on that information i would like to create a chart displaying the created tickets and closed tickets per month. for that reason i created a meassure count(CreateDate) to get all the created tickets within my time period and added dimensions to polulate the filter pane (YEAR(CreateDate), MONTH(CreateDate). The created ticket value is ok for me and the results are ok. The problem is the meassure for the closed tickets. For that, i created a meassure count(CloseDate).

My problem is now that my filter pane filters the dates for my CreateTime entries but for that case, the filter should filter the YEAR(CloseDate) and (MONTH(CloseDate) entries, so the result of the CloseDate is wrong.

Is there a way to create a filter pane that filters CreateDate and CloseDate entries at the same time or another way to get the right data? I tried multiple filter options without success .

Best regards

Switzly

Tags (1)
2 Replies
srchilukoori
Valued Contributor

Re: Filtering multiple date values in Qlik Sense

Hi Stefan,

Try creating new fields ActivityDate & Type as shown in the attached qvf. You can use the Activity Date/ month/ year to show the no. of tickets created and closed in each period. !

srchilukoori
Valued Contributor

Re: Filtering multiple date values in Qlik Sense

Filtering on the activity date will yield you the tickets that are created on/after the start date and closed on/before the end date.