How to use weekly data in daily analysis

[#1]

I have huge payroll data with weekly date (meaning
consecutive Thursdays). I need to use that for daily analysis.

So for example when I am creating a chart (where dimension
is Date and expression is “count( disctinct PersonelNumber)” ) I want to have a
workforce shown for each day, not only for Thursdays. In payroll I have field “Date
from” and “Date to” but I do not know how to use it.

What would be the best approach to such issue? Any help would be appreciated.

Thanks,

Mat

[Gysbert_Wassenaar]

See this blog post: Creating Reference Dates for Intervals

[jonathandienst]

Hi

These may help

http://community.qlik.com/docs/DOC-3786

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field

HTH

Jonathan

[#4]

Thank you for your suggestions. I have finally created additional table (something like mapping) with daily dates assigned to weekly dates.

Regards,

Mat