This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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, label0, 00-141, 15-292, 30-443, 45-59];MAP label USING IntervalMap;
Mid ([Timestamp],4,2) as label
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,
View solution in original post
Please upload sample data.
How do I attach/upload data?
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
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>