topic TimeStamp in QlikView

TimeStamp

Sat, 13 Feb 2010 00:44:46 GMT

Hiya Folks.

I have a problem that has been racking my brains for the last while so if anyone could help I'd appreciate it a lot. I've created a few list boxes that can show me the data for a certain time period (a list box for each year/month/day)

What i want to do is also create a list box that would show me the data for a certain time period during the day. ie shifts in a company, so from 9am to 5pm or 5pm to 12am.

The times dont really make a difference, they're only an example. I just want to be able to choose from my list box 1 of 2 shift periods.

Thanks in advance,
Barry

TimeStamp

johnw — Sat, 13 Feb 2010 01:05:13 GMT

So do you want this list box?

Time Period
9am to 5pm
5pm to 12am

Or two list boxes, each with all of the times in that specific period?

9am to 5pm 5pm to 12am
9:32 am 7:20 pm
9:37 am 9:30 pm
10:01 am 10:40 pm
4:55 pm

For the first, just add a Time Period field in your script. For the second, create a list box, title it 9am to 5pm, for the field select <Expression>, and enter expression if(Time >= time#('0900','hhmm') and Time <= time#('1700','hhmm),Time). Do the same for the other period.

Or was it something else you wanted?

TimeStamp

Sat, 13 Feb 2010 14:38:17 GMT

HI there,

Thanks for the quick response. It was the first option I wanted. So I've added a SET timeperiod(day;night)

to my script.

This represents a day shift or night shift. When I create a list box though, how do I activate that new field so i see

it in the list box,

Sorry I'm a newbie! thanks

TimeStamp

Sat, 13 Feb 2010 14:43:21 GMT

sorry thats a stupid question i've figured it out.

thanks again for your help