Discussion Board for collaboration on QlikView Scripting.
I'm loading DATE/DEP fields. For some DATE/DEP I get no datasets (rows) via ODBC.
This looks like:
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:
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.
Go to Solution.
check the attached sample....