Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intervalmapping problem

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


1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
sushil353
Master II
Master II

Please upload sample data.

Not applicable
Author

How do I attach/upload data?

Not applicable
Author

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>

Not applicable
Author

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post