Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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