topic Re: Create Morning, evening, and night in QlikView

Create Morning, evening, and night

Thu, 09 Apr 2015 07:59:37 GMT

Hi all! thanks for taking time to read this newbie question!

I'm trying to do a select box like this

Morning

Evening

Night

Where:

Morning needs to be requestHOUR from 8:00 to 14:00

Evening needs to be requestHOUR from 14:00 to 18:00

Night needs to be requestHOUR from 18:00 to 00:00

This should select only those items between those hours.

Thanks all!!

Re: Create Morning, evening, and night

pokassov — Thu, 09 Apr 2015 08:03:41 GMT

Hi!

You can add this field in script:

load,

If(requestHOUR>=8/24 and requestHOUR<14/24, 'Morning',

If(requestHOUR>=14/24 and requestHOUR<18/24, 'Evening',

If(requestHOUR>=18/24 , 'Night','N/A')

)

) as Shift

from ...

Re: Create Morning, evening, and night

Anonymous — Thu, 09 Apr 2015 08:09:24 GMT

do you have a time field in your table if yes,

you can do it in two way.

1) load a inline mapping table with Time and DayNight column.

Time , Daynight

8:00,Morning

...

etc

and use applymap to add Daynight column in main table .

you can use if condition

if (Time >=8 and Time <=14 , 'Morning') ....... etc as Daynight

both will solve your problem you may need to convert your hrs in num.

Thanks

BKC

Re: Create Morning, evening, and night

buzzy996 — Thu, 09 Apr 2015 08:29:23 GMT

try this,by using simple if statement..

if(requestHOUR>=8 and requestHOUR<=14,'Morning ',

if(requestHOUR>=14 and requestHOUR<=18,'Evening ',

if(requestHOUR>=18 and requestHOUR<8,'Night ',null())))

if u want use in load script just name as the above expression with alias name else u can use that script dirctly in ur expression wherever u want.

Re: Create Morning, evening, and night

Thu, 09 Apr 2015 08:42:37 GMT

Sorry but still i dont get it trying to do it but can't, do you have any complete example?

Re: Create Morning, evening, and night

buzzy996 — Thu, 09 Apr 2015 08:45:39 GMT

is't possible to share ur .qvw?

Re: Create Morning, evening, and night

Thu, 09 Apr 2015 08:55:11 GMT

PFA

Re: Create Morning, evening, and night

Thu, 09 Apr 2015 09:09:11 GMT

Huge thanks! i've just realized what i was doing wrong!