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: 
Not applicable

How to begin

Qlik sense desktop

I want to create a line chart that shows how many my tickets where open at the end of each month.

For x dimension i wanted to be time. At the moment I have a master calendar with the field month and year that i´m using on other graphs.

The data that I have is something like this:

    

idticket_state_idcreate_timechange_time
12941202/01/201402/01/2014
12942202/01/201402/02/2014
12943202/01/201403/06/2014
12944202/01/201412/09/2014

that goes from Jan_2014 to Dez_2016, but it to continue. Change_time is when the ticket was closed.

Also through id i want to connect to other tables where i have information on who is the client and so on.

So is there any need to rearange the data? How to i make the graph?

2 Replies
sunny_talwar

May be look into IntervalMatch to connect your table to a master calendar. Once you have this setup, you can easily use Month from your master calendar as your dimension.

shubham_singh
Partner - Creator II
Partner - Creator II

Assuming that you have all the dates from minimim of create date to maximum of change date in field DateNum.

Use below code.

Tickets:

LOAD

*,

num(create_time) & '|' & num(change_time) as KeyFromToDate

FROM file.qvd;

TempIntervalMatch:

IntervalMatch(DateNum)

LOAD Distinct

num(create_time) as Start,

num(change_time) as End

Resident Tickets;

IntervalMatch:

LOAD Distinct

Start & '|' & End as KeyFromToDate,

DateNum

Resident TempIntervalMatch;

Drop Table TempIntervalMatch;

This will create a intermediate table between Tickets & Master Calendar so that you will have id corresponding to every date between start date & change date.