Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

IntervalMatch issue

Hi guys, I got a small but important problem when plotting my graph

Here is my loading script

TimeInMinutes:

LOAD * INLINE [

    MinutesStart, MinutesEnd

    00:00:00, 00:14:59

    00:15:00, 00:29:59

    00:30:00, 00:44:59

    00:45:00, 00:59:59

    01:00:00, 01:14:59

    01:15:00, 01:29:59

    01:30:00, 01:44:59

    01:45:00, 01:59:59

    02:00:00, 02:14:59

    02:15:00, 02:29:59

    02:30:00, 02:44:59

    02:45:00, 02:59:59

    03:00:00, 03:14:59

    03:15:00, 03:29:59

    03:30:00, 03:44:59

    03:45:00, 03:59:59

    04:00:00, 11:59:59

];

LOAD CNTR_N_F,

     TIME_C_F,

     START_DT,

FROM

[Output Result.xls]

(biff, embedded labels, table is Sheet1$);

Event_Start_Diff_Table:

IntervalMatch (TIME_C_F) LOAD MinutesStart as Start1, MinutesEnd as End1 Resident TimeInMinutes;

---------------------------------------------------------------------------------------------------------

Basically, the table TimeInMinutes is the bucket. IntervalMatch is used to throw 'TIME_C_F' into the respective bucket in TimeInMinutes.

Dimension = Start1

Expression = Count(TIME_C_F)

My problem is that if there is no records that falls into 03:30:00, 03:44:59, it will not display the particular column at all.

I already tried
(1) Unchecked 'Suppress Zero-Values' and 'Suppress Missing' under 'Presentation'

(2) Checked 'Show all values' under 'Dimension'

but all doesn't work.

The graph below is the graph I am getting now.  Any help will be appreciated.

1 Reply
whiteline
Honored Contributor II

Re: IntervalMatch issue

Hi.

You can try to create another expression =1 and make it invisible.

Community Browser