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

graphical activity overview

All,

I've got a database with a lot of repetitive activities like:

activity                        frequency          start date

cleaning xxxxx              1 months          01-15-2015

check xxxxxx              6 months            01-24-2015

order xxxx                    1 week              01-02-2015

etc

With this information I would like to create an overview something like:

week01-152-'153-'154-'155-'156-'157-'158-'159-'1510-'1511-'1512-'1513-'1514-'15...
cleaning xxxxxxxxx
check xxxxxxx
order xxxxxxxxxxxxxxxxxxx
etc

'

any tips or tricks?

regards

Per

3 Replies
crusader_
Partner - Specialist
Partner - Specialist

Hello Perry,

Firstly using script convert your frequency to single grain (week or day depends on your data).

Secondly use Interval match.

Thirdly create custom week field (week-year).

Similar example you can find here

Re: Heat map - Length of Stay for 24 hr

Hope this helps you

Regards,

Andrei

Not applicable
Author

Hi Andrei,

The example you provided gets me half-way there. To make the example work, I need to provide a startdate and enddate for each event. The only information I've got is a startdate and frequency of the event. So if I want to use the example then I would have to generate a table with future events.

for example:

activity                  frequency      startdate

cleaning xxxxx              1 months          01-15-2015

order xxxx                    1 week              01-02-2015


should result in a new table like:

activity                       startdate             enddate

cleaning xxxxx         01-15-2015       01-15-2015

cleaning xxxxx         02-15-2015       02-15-2015

cleaning xxxxx         03-15-2015       03-15-2015

etc

order xxxx                 01-02-2015       01-02-2015

order xxxx                 01-09-2015       01-09-2015

order xxxx                 01-16-2015       01-16-2015

etc


Is there an easy way to do this?

crusader_
Partner - Specialist
Partner - Specialist

Hi,

I believe that it rather simple to do in your script:

1. Bring to single basis of your frequency using if statement or applymap() function within match() function.

The specific way how to do it very depends on your data.

2. Create End Date field by adding days, weeks, months, years  to your startDate.

Please find attached small example.

Hope this helps you.

Regards,

Andrei