Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Scales Date / dimension

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.

Community Browser