topic Intervalmapping problem in QlikView

Intervalmapping problem

Thu, 14 Mar 2013 08:57:08 GMT

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

Re: Intervalmapping problem

sushil353 — Thu, 14 Mar 2013 09:00:10 GMT

Please upload sample data.

Re: Intervalmapping problem

Thu, 14 Mar 2013 09:27:09 GMT

How do I attach/upload data?

Re: Intervalmapping problem

Thu, 14 Mar 2013 09:29:03 GMT

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>

Re: Intervalmapping problem

Thu, 14 Mar 2013 09:32:24 GMT

Re: Intervalmapping problem

Gysbert_Wassenaar — Thu, 14 Mar 2013 09:46:41 GMT

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