1 Reply Latest reply: Nov 23, 2012 8:47 AM by Fernando Suzuki RSS

    Missing dataset for calculating rate

      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

      A1
      01.01.2012A1
      02.01.2012A4
      02.01.2012B3

       

      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.2012A1
      01.01.2012A1
      02.01.2012A4
      01.01.2012B-
      02.01.2012B3

      ...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