Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to use weekly data in daily analysis

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

3 Replies

Re: How to use weekly data in daily analysis

See this blog post: Creating Reference Dates for Intervals


talk is cheap, supply exceeds demand
MVP
MVP

Re: How to use weekly data in daily analysis

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
Not applicable

Re: How to use weekly data in daily analysis

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

Regards,

Mat

Community Browser