Intervalmapping problem

[#1]

I got at spreedsheet with a field consisting af a timestamp ex. 01.12.50

I would like to make an interval so I can filter the first quarter of the hour, the second quarter - and so on.

I have tried the following

IntervalMap:MAPPING LOAD * INLINE [
key, label
0, 00-14
1, 15-29
2, 30-44
3, 45-59
]
;MAP label USING IntervalMap;

load

[Timestamp],

Mid ([Timestamp],4,2) as label

Resident [Time];

But It doesnt filter korrekt afterwards - meaning when i qlik on 00-14 it should give me all

the rows in the spredssheet where the minutes are between 0 and 14

[sushil353]

Please upload sample data.

[#3]

How do I attach/upload data?

[#4]

Hi sushil

I couldnt upload data so here I have attached the spreadsheet

Fra: sushil kumar

Sendt: 14. marts 2013 10:00

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: Intervalmapping problem

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Intervalmapping problem

created by sushil kumar<http://community.qlik.com/people/sushil353> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/321866#321866>

[#5]

[Gysbert_Wassenaar · Accepted solution]

Try this instead: floor(Minute(Timestamp)/15) as label,