https://community.qlik.com/t5/Connectivity-Data-Prep/Turning-an-End-Month-Value-into-Working-Day-split/m-p/2029244#M11920 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/179241">@RichardLee</a>&nbsp; Could you please provide the sample data and expected output?</P> Tue, 24 Jan 2023 10:44:06 GMT sidhiq91 2023-01-24T10:44:06Z https://community.qlik.com/t5/Connectivity-Data-Prep/Turning-an-End-Month-Value-into-Working-Day-split/m-p/2029235#M11919 <P>I have a set of NL codes, Group, EoM and value.</P> <P>I would like to split this into working days for each of the NL codes and NL &amp; Group so I can calculate a YTD for each of them.</P> <P>this is held on a Excel Sheet which I bring into Qlik any help would be fantastic.</P> <P>&nbsp;</P> <TABLE width="341"> <TBODY> <TR> <TD width="64">Acc #</TD> <TD width="64">Dept</TD> <TD width="75">Month</TD> <TD width="74">&nbsp;Value&nbsp;</TD> <TD width="64">cc</TD> </TR> <TR> <TD>1000</TD> <TD>10</TD> <TD>31/01/2023</TD> <TD>10,307.00</TD> <TD>01</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Tue, 24 Jan 2023 10:30:41 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Turning-an-End-Month-Value-into-Working-Day-split/m-p/2029235#M11919 RichardLee 2023-01-24T10:30:41Z https://community.qlik.com/t5/Connectivity-Data-Prep/Turning-an-End-Month-Value-into-Working-Day-split/m-p/2029244#M11920 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/179241">@RichardLee</a>&nbsp; Could you please provide the sample data and expected output?</P> Tue, 24 Jan 2023 10:44:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Turning-an-End-Month-Value-into-Working-Day-split/m-p/2029244#M11920 sidhiq91 2023-01-24T10:44:06Z