Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Create Start and End Date from one date field

Hello everyone, 

 

My company recently started a campaign program last year. We need to monitor our performance. We have a list of records in this format.

 

DateTelephone NumberCampaign
01/01/20201234551Promotion 10
01/01/20201234552Promotion 11
01/01/20201234567Promotion 1
01/01/20201234566Promotion 2
06/01/20201234551Promotion 10
06/01/20201234552Promotion 11
06/01/20201234567Promotion 4
06/01/20201234566Promotion 7

 

from the above table,  we need to express the records in the format below

 

S/NTelephoneCampaignStart DateEnd DateDuration (days)(
11234551Promotion 101/1/2020still aliveOn-going
21234552Promotion 111/1/2020still aliveOn-going
31234567Promotion 11/1/20201/5/20205
41234566Promotion 21/1/20201/5/20205
51234567Promotion 41/6/2020still aliveOn-going
61234566Promotion 71/6/2020still aliveOn-going

 

 

Please can anyone help me with a clue? 

 

Regards

 

Labels (2)
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, it may put you on the right track, but I am not sure:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

If you wish to do some further searching in this area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are hundreds of mostly how-to related posts in this area from our experts, so it may prove very useful to you in coming up with ideas.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

3 Replies
Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, it may put you on the right track, but I am not sure:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

If you wish to do some further searching in this area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are hundreds of mostly how-to related posts in this area from our experts, so it may prove very useful to you in coming up with ideas.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
akpofureenughwu
Creator III
Creator III
Author

Hello BrettBleess,

 

Thank you for the link.. 

 

https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467...

 

The link above is helpful however rather than the todate for a running campaign to be today's date can it be change to on-going?

 

Regards

Brett_Bleess
Former Employee
Former Employee

Best I have is the following, not sure it is what you need:

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

Hopefully one of those may help further.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.