Hello QVer,
I'm loading DATE/DEP fields. For some DATE/DEP I get no datasets (rows) via ODBC.
This looks like:
DATE
| DEP
| VALUE
|
|---|
01.01.2012 | A | 1 |
| 01.01.2012 | A | 1 |
| 02.01.2012 | A | 4 |
| 02.01.2012 | B | 3 |
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:
DATE
| DEP
| VALUE |
|---|
| 01.01.2012 | A | 1 |
| 01.01.2012 | A | 1 |
| 02.01.2012 | A | 4 |
| 01.01.2012 | B | - |
| 02.01.2012 | B | 3 |
...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
