Interval Match - Several Dimensions

Anonymous — Wed, 13 Aug 2014 08:04:05 GMT

I am currently have data which shows for recruitment. Each Job ref has various stages, i.e. Stage1 - Authorised to Advertised / Stage2 - Advertised to Closing Date / Stage3 - Closing Date to Shortlisting Date / Stage 4 - Shortlisting Date to Interview Date.

I have the same criteria for the grouping of the stages. i.e. 0-10 days / 11-20 Days / 21-30 Days.

I am probably being a bit thick here, but which is the best way to use interval match to show how long each stage is taking (within the groupings)

E.g. There are 10 applications

Total Stage 1 Applications 0-10 Days = 3

Total Stage 1 Applications 11 - 20 Days = 5

Total Stage 1 Applications - 21 - 30 Days = 2

Total Stage 2 Applications 0-10 Days = 1

Total Stage 2 Applications 11-20 Days = 2

Total Stage 2 Applications 21-30 Days = 7

Total Stage 3 Applications 0-10 Days = 5

Total Stage 3 Applications 11-20 Days = 3

Total Stage 3 Applications 21-30 Days = 2

Total Stage 4 Applications 0-10 Days = 8

Total Stage 4 Applications11-20 Days = 1

Total Stage 4 Applications 21-30 Days = 1

I will be showing these in graphs in the report.

Many thanks

Phil

topic Interval Match - Several Dimensions in QlikView

Interval Match - Several Dimensions