How to use weekly data in daily analysis - Qlik Community

Report Inappropriate Content · ‎2014-10-31

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 · ‎2014-10-31

See this blog post: Creating Reference Dates for Intervals

talk is cheap, supply exceeds demand

jonathandienst · ‎2014-10-31

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2014-11-11

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

Regards,

Mat