0 Replies Latest reply: Jun 21, 2013 3:58 AM by David AMOSSE RSS

    Scales Date / dimension

    David AMOSSE

      Hi,

       

      I'm working on QlikView since 1 month.

       

      I've got a problem with time scale.

       

      I've got 2 tables :

       

      First One:

      CALL_TABLE:

      ID_CALL

      STATE

      SUBSTATE

      OPEN_WEEK

      CLOSE_WEEK

       

      Second One :

      FREEZE_TABLE :

      ID_FREEZE

      ID_CALL

      IS_FROZEN

      WEEK_START_FREEZE

      WEEK_END_FREEZE

       

      I've got also a main calendar.

       

      This code is working :

       

      Number Calls Opened before Week X = (Week(today())-14) :

      =count({<[OPEN_WEEK]={"<= $(=week(today())-14)"}>}[ID_CALL])

       

      Number Calls Closed before week X :

      =count({<[CLOSE_WEEK]={"<= $(=week(today())-14)"}>*<[STATE]={'CLOSED INT', 'CLOSED EXT'}>*1-$<[SUBSTATE]={'CANCELLED'}>}[ID_CALL])

       

      Number Calls Frozen with before WEEK_START_FREEZE <= Week X and WEEK_END_FREEZE > Week X :

      =count({<[WEEK_START_FREEZE]={"<= $(=week(today())-14)"}>*<[WEEK_END_FREEZE]={"> $(=week(today())-14)"}>*<[IS_FROZEN]={'1'}>}[ID_FREEZE)

       

      In charts, with no dimension, it's working perfectly.

       

      1-)

      I'd like to make a chart with a scale of week.

      Dimension =Number of weeks : 11 12 13 14 15 16 17 18 19 20

      Is it possible to make a chart with the 3 numbers (Opened, Closed, Frozen) by week ?

       

      2-)

      Is it possible to get back in expression the dimension value ?

      For exemple, when the week dimension = 12, i'd like to get back 12 for the expression.

       

      Thanks a lot.