Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi dj,
check the attached sample....