https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663089#M448975 <P>Have a look at the following Design Blog post, it may put you on the right track, but I am not sure:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527</A></P> <P>If you wish to do some further searching in this area, use the following link:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog</A></P> <P>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.</P> <P>Regards,<BR />Brett</P> Mon, 06 Jan 2020 20:31:37 GMT Brett_Bleess 2020-01-06T20:31:37Z https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663084#M448973 <P>Hello everyone,&nbsp;</P><P>&nbsp;</P><P>My company recently started a campaign program last year. We need to monitor our performance. We have a list of records in this format.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Telephone Number</TD><TD>Campaign</TD></TR><TR><TD>01/01/2020</TD><TD>1234551</TD><TD>Promotion 10</TD></TR><TR><TD>01/01/2020</TD><TD>1234552</TD><TD>Promotion 11</TD></TR><TR><TD>01/01/2020</TD><TD>1234567</TD><TD>Promotion 1</TD></TR><TR><TD>01/01/2020</TD><TD>1234566</TD><TD>Promotion 2</TD></TR><TR><TD>06/01/2020</TD><TD>1234551</TD><TD>Promotion 10</TD></TR><TR><TD>06/01/2020</TD><TD>1234552</TD><TD>Promotion 11</TD></TR><TR><TD>06/01/2020</TD><TD>1234567</TD><TD>Promotion 4</TD></TR><TR><TD>06/01/2020</TD><TD>1234566</TD><TD>Promotion 7</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>from the above table,&nbsp; we need to express the records in the format below</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>S/N</TD><TD>Telephone</TD><TD>Campaign</TD><TD>Start Date</TD><TD>End Date</TD><TD>Duration (days)(</TD></TR><TR><TD>1</TD><TD>1234551</TD><TD>Promotion 10</TD><TD>1/1/2020</TD><TD>still alive</TD><TD>On-going</TD></TR><TR><TD>2</TD><TD>1234552</TD><TD>Promotion 11</TD><TD>1/1/2020</TD><TD>still alive</TD><TD>On-going</TD></TR><TR><TD>3</TD><TD>1234567</TD><TD>Promotion 1</TD><TD>1/1/2020</TD><TD>1/5/2020</TD><TD>5</TD></TR><TR><TD>4</TD><TD>1234566</TD><TD>Promotion 2</TD><TD>1/1/2020</TD><TD>1/5/2020</TD><TD>5</TD></TR><TR><TD>5</TD><TD>1234567</TD><TD>Promotion 4</TD><TD>1/6/2020</TD><TD>still alive</TD><TD>On-going</TD></TR><TR><TD>6</TD><TD>1234566</TD><TD>Promotion 7</TD><TD>1/6/2020</TD><TD>still alive</TD><TD>On-going</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Please can anyone help me with a clue?&nbsp;</P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:35:00 GMT https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663084#M448973 akpofureenughwu 2024-11-16T01:35:00Z https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663089#M448975 <P>Have a look at the following Design Blog post, it may put you on the right track, but I am not sure:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527</A></P> <P>If you wish to do some further searching in this area, use the following link:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog</A></P> <P>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.</P> <P>Regards,<BR />Brett</P> Mon, 06 Jan 2020 20:31:37 GMT https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663089#M448975 Brett_Bleess 2020-01-06T20:31:37Z https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663109#M448978 <P>Hello BrettBleess,</P><P>&nbsp;</P><P>Thank you for the link..&nbsp;</P><P>&nbsp;</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467840" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467840</A></P><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>Regards</P> Mon, 06 Jan 2020 22:00:33 GMT https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663109#M448978 akpofureenughwu 2020-01-06T22:00:33Z https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663116#M448979 <P>Best I have is the following, not sure it is what you need:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581</A></P> <P>Hopefully one of those may help further.</P> <P>Regards,<BR />Brett</P> Mon, 06 Jan 2020 22:14:14 GMT https://community.qlik.com/t5/QlikView/Create-Start-and-End-Date-from-one-date-field/m-p/1663116#M448979 Brett_Bleess 2020-01-06T22:14:14Z