topic Data with different Granularity in App Development https://community.qlik.com/t5/App-Development/Data-with-different-Granularity/m-p/1779872#M60642 <P>Hi All,</P><P>Thanks in advance for your help.</P><P>I come across a situation where some data is in moth level and another data in Week level.</P><P>I have two tables Actual in weekly and forecast data in Monthly level. How to handle this type of data in script level and front end?</P><P>Example- Actula Data is in Week Level</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD><P>&nbsp;</P><P>level</P></TD><TD>Date</TD><TD>Sales</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>12-12-20</TD><TD>400</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>19-12-20</TD><TD>300</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>26-12-20</TD><TD>521</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>02-01-21</TD><TD>500</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>09-01-21</TD><TD>300</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>16-01-21</TD><TD>33</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>23-01-21</TD><TD>155</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>30-01-21</TD><TD>58</TD></TR><TR><TD>&nbsp;</TD><TD>Actual</TD><TD>06-02-21</TD><TD>20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Forecast table:</P><TABLE border="1"><TBODY><TR><TD>Product&nbsp;</TD><TD>Level</TD><TD>Date</TD><TD>Sales</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Dec-2020</TD><TD>500</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Jan-2021</TD><TD>1000</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Feb-2021</TD><TD>895</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Mar-2021</TD><TD>125</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want some Bar chat with measure Actual/Budget of net sales like this. In some charts I want show data weekly level in line graph and bar graph. I want to calculate WTD is it possible in this case?</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:31:46 GMT kmmqlick 2024-11-16T17:31:46Z Data with different Granularity https://community.qlik.com/t5/App-Development/Data-with-different-Granularity/m-p/1779872#M60642 <P>Hi All,</P><P>Thanks in advance for your help.</P><P>I come across a situation where some data is in moth level and another data in Week level.</P><P>I have two tables Actual in weekly and forecast data in Monthly level. How to handle this type of data in script level and front end?</P><P>Example- Actula Data is in Week Level</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD><P>&nbsp;</P><P>level</P></TD><TD>Date</TD><TD>Sales</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>12-12-20</TD><TD>400</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>19-12-20</TD><TD>300</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>26-12-20</TD><TD>521</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>02-01-21</TD><TD>500</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>09-01-21</TD><TD>300</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>16-01-21</TD><TD>33</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>23-01-21</TD><TD>155</TD></TR><TR><TD>A</TD><TD>Actual</TD><TD>30-01-21</TD><TD>58</TD></TR><TR><TD>&nbsp;</TD><TD>Actual</TD><TD>06-02-21</TD><TD>20</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Forecast table:</P><TABLE border="1"><TBODY><TR><TD>Product&nbsp;</TD><TD>Level</TD><TD>Date</TD><TD>Sales</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Dec-2020</TD><TD>500</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Jan-2021</TD><TD>1000</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Feb-2021</TD><TD>895</TD></TR><TR><TD>A</TD><TD>Budget</TD><TD>Mar-2021</TD><TD>125</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want some Bar chat with measure Actual/Budget of net sales like this. In some charts I want show data weekly level in line graph and bar graph. I want to calculate WTD is it possible in this case?</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:31:46 GMT https://community.qlik.com/t5/App-Development/Data-with-different-Granularity/m-p/1779872#M60642 kmmqlick 2024-11-16T17:31:46Z Re: Data with different Granularity https://community.qlik.com/t5/App-Development/Data-with-different-Granularity/m-p/1779891#M60643 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ksrinivasan_0-1612374635704.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48416i1771690CC3EB4E55/image-size/medium?v=v2&amp;px=400" role="button" title="Ksrinivasan_0-1612374635704.png" alt="Ksrinivasan_0-1612374635704.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ksrinivasan_1-1612374649583.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48417iD8D449D29944CAEF/image-size/medium?v=v2&amp;px=400" role="button" title="Ksrinivasan_1-1612374649583.png" alt="Ksrinivasan_1-1612374649583.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ksrinivasan_2-1612374659628.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/48418iCF845AAA4CFACAA3/image-size/medium?v=v2&amp;px=400" role="button" title="Ksrinivasan_2-1612374659628.png" alt="Ksrinivasan_2-1612374659628.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 03 Feb 2021 17:52:16 GMT https://community.qlik.com/t5/App-Development/Data-with-different-Granularity/m-p/1779891#M60643 Ksrinivasan 2021-02-03T17:52:16Z