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.
