topic Re: How to use weekly data in daily analysis in QlikView https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742381#M473561 <HTML><HEAD></HEAD><BODY><P>Thank you for your suggestions. I have finally created additional table (something like mapping) with daily dates assigned to weekly dates.</P><P></P><P>Regards,</P><P>Mat</P></BODY></HTML> Tue, 11 Nov 2014 16:53:01 GMT 2014-11-11T16:53:01Z How to use weekly data in daily analysis https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742378#M473558 <HTML><HEAD></HEAD><BODY><P>I have huge payroll data with weekly date (meaning<BR />consecutive Thursdays). I need to use that for daily analysis. </P><P></P><P>So for example when I am creating a chart (where dimension<BR />is Date and expression is “count( disctinct PersonelNumber)” ) I want to have a<BR />workforce shown for each day, not only for Thursdays. In payroll I have field “Date<BR />from” and “Date to” but I do not know how to use it.</P><P></P><P>What would be the best approach to such issue? Any help would be appreciated.</P><P></P><P>Thanks,</P><P>Mat</P></BODY></HTML> Fri, 31 Oct 2014 09:29:32 GMT https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742378#M473558 2014-10-31T09:29:32Z Re: How to use weekly data in daily analysis https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742379#M473559 <HTML><HEAD></HEAD><BODY><P>See this blog post: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Creating Reference Dates for Intervals</A></P></BODY></HTML> Fri, 31 Oct 2014 09:34:00 GMT https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742379#M473559 Gysbert_Wassenaar 2014-10-31T09:34:00Z Re: How to use weekly data in daily analysis https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742380#M473560 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>These may help</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3786">http://community.qlik.com/docs/DOC-3786</A></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field" style="font-size: 10pt; line-height: 1.5em;">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field</A></P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Fri, 31 Oct 2014 09:50:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742380#M473560 jonathandienst 2014-10-31T09:50:26Z Re: How to use weekly data in daily analysis https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742381#M473561 <HTML><HEAD></HEAD><BODY><P>Thank you for your suggestions. I have finally created additional table (something like mapping) with daily dates assigned to weekly dates.</P><P></P><P>Regards,</P><P>Mat</P></BODY></HTML> Tue, 11 Nov 2014 16:53:01 GMT https://community.qlik.com/t5/QlikView/How-to-use-weekly-data-in-daily-analysis/m-p/742381#M473561 2014-11-11T16:53:01Z