<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to split timestamp in work days in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-split-timestamp-in-work-days/m-p/584398#M680394</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;Hi,&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;I´m openning a new post since I made some confuse.&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;For example. &lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;I have a interval date:&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em; font-weight: inherit; font-style: inherit;"&gt;Start date:&lt;/SPAN&gt;&lt;SPAN style="font-family: inherit; font-size: 10pt; line-height: 1.5em; font-weight: inherit; font-style: inherit;"&gt;28/04/2014 15:31:00&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em; font-weight: inherit; font-style: inherit;"&gt;End Date: 30/04/2014 08:43:00&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P&gt;I &lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;would like to have this result, which means all the work days from 09:00 until 18:00. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;" width="269"&gt;&lt;TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl63" height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="36"&gt;lState&lt;/TD&gt;&lt;TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;ShiftID&lt;/TD&gt;&lt;TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="96"&gt;TZStart&lt;/TD&gt;&lt;TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="96"&gt;TZEnd&lt;/TD&gt;&lt;/TR&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;" width="36"&gt;24&lt;/TD&gt;&lt;TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;1&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;28/04/2014 15:31&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;28/04/2014 18:00&lt;/TD&gt;&lt;/TR&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;" width="36"&gt;24&lt;/TD&gt;&lt;TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;2&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;28/04/2014 09:00&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;29/04/2014 18:00&lt;/TD&gt;&lt;/TR&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;" width="36"&gt;24&lt;/TD&gt;&lt;TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;3&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;29/04/2014 09:00&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;29/04/2014 08:43&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I was trying to see this &lt;A href="https://community.qlik.com/thread/67078"&gt;Splitting the data - On the way to granularity&lt;/A&gt;, but I couldn´t make in my way.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any help would be appreciated.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best Regards&lt;/P&gt;&lt;P&gt;Fernando&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 01 May 2014 16:19:52 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-05-01T16:19:52Z</dc:date>
    <item>
      <title>How to split timestamp in work days</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-split-timestamp-in-work-days/m-p/584398#M680394</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;Hi,&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;I´m openning a new post since I made some confuse.&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;For example. &lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;I have a interval date:&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em; font-weight: inherit; font-style: inherit;"&gt;Start date:&lt;/SPAN&gt;&lt;SPAN style="font-family: inherit; font-size: 10pt; line-height: 1.5em; font-weight: inherit; font-style: inherit;"&gt;28/04/2014 15:31:00&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="font-size: 10pt; line-height: 1.5em; font-weight: inherit; font-style: inherit;"&gt;End Date: 30/04/2014 08:43:00&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P&gt;I &lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;would like to have this result, which means all the work days from 09:00 until 18:00. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;" width="269"&gt;&lt;TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl63" height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="36"&gt;lState&lt;/TD&gt;&lt;TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;ShiftID&lt;/TD&gt;&lt;TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="96"&gt;TZStart&lt;/TD&gt;&lt;TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="96"&gt;TZEnd&lt;/TD&gt;&lt;/TR&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;" width="36"&gt;24&lt;/TD&gt;&lt;TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;1&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;28/04/2014 15:31&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;28/04/2014 18:00&lt;/TD&gt;&lt;/TR&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;" width="36"&gt;24&lt;/TD&gt;&lt;TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;2&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;28/04/2014 09:00&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;29/04/2014 18:00&lt;/TD&gt;&lt;/TR&gt;&lt;TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"&gt;&lt;TD class="xl64" height="20" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;" width="36"&gt;24&lt;/TD&gt;&lt;TD class="xl64" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="41"&gt;3&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;29/04/2014 09:00&lt;/TD&gt;&lt;TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-width: 0px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"&gt;29/04/2014 08:43&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I was trying to see this &lt;A href="https://community.qlik.com/thread/67078"&gt;Splitting the data - On the way to granularity&lt;/A&gt;, but I couldn´t make in my way.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any help would be appreciated.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best Regards&lt;/P&gt;&lt;P&gt;Fernando&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 01 May 2014 16:19:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-split-timestamp-in-work-days/m-p/584398#M680394</guid>
      <dc:creator />
      <dc:date>2014-05-01T16:19:52Z</dc:date>
    </item>
  </channel>
</rss>

