Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this instead: floor(Minute(Timestamp)/15) as label,
Please upload sample data.
How do I attach/upload data?
Hi sushil
I couldnt upload data so here I have attached the spreadsheet
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>
Try this instead: floor(Minute(Timestamp)/15) as label,