topic Re: Converting minutes into 30 minute time slots in QlikView

Converting minutes into 30 minute time slots

Wed, 20 Mar 2013 15:52:20 GMT

Hello

I have a grid chart that I need to drilldown on time.

I have created a group based on a field that contains minutes.

The top level of the group is hours and I have done this.

However, the second level of the group needs to be 30 minute time slots.

e.g.

35 minutes = 0.50

65 minutes = 1.00

85 minutes = 1.00

95 minutes = 1.50

Can anyone advise please?

Wed, 20 Mar 2013 17:01:50 GMT

Try with this:

Create a new field in your table and add in the group:

=Floor(Frac(<DateField>) / MakeTime(1), 0.5) as <FieldName>

Regards,

Ricardo

Wed, 20 Mar 2013 17:27:10 GMT

Thanks Ricardo.

Will try tomorrow in work

azimabadi — Wed, 20 Mar 2013 18:04:52 GMT

Hi Maseda,

if you have minutes in a field i think this expression can help you:

= Div( Min , 30 ) * 0.5

please find attached QVW for more refrence.

Regards

Peyman

Wed, 20 Mar 2013 20:17:42 GMT

Thanks Reyman.

Again, I will try this tomorrow also.