Missing dataset for calculating rate

Fri, 23 Nov 2012 12:44:58 GMT

Hello QVer,

I'm loading DATE/DEP fields. For some DATE/DEP I get no datasets (rows) via ODBC.

This looks like:

Count(DATE|A)=3

Count(DATE|B)=1 -> should be 2 but 01.01.2012|B is missing.

For calculating whole selected periods (i.e. week, month, year) with all days I need also DATE rows per DEP not originally comming via ODBC.

It should look like:

...ASO

In other words I need additional DATE|DEP sets for calculating a rate.

Should be done in QV script.

Tried a lot. How to solve that? Thanks. Regards.

dj_skbs

Re: Missing dataset for calculating rate

fosuzuki — Fri, 23 Nov 2012 13:47:29 GMT

Hi dj,

check the attached sample....