Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

how to Assign value to the rows ?

I have a column in which i have Time as follows

Time

12.00 AM

12.14 AM

13.12 AM

03.30 PM

04.00 PM

02.30 AM

.

.

.

n numbers of rows

I want to assign  it as following

Time                        Assign Value

12.00 AM                    12.00 AM

12.14 AM                    12.00 AM

13.12 AM                     13.00 AM

03.30 PM                     03.30 PM

04.00 PM                     04.00 AM

02.30 AM                     02.30 AM

.

.

n numbers of rows

Thanx in Advance

Labels (2)
14 Replies
Gysbert_Wassenaar

Something like this:

LOAD

     Time,

     Time(Floor(Time,1/48)) As [Assign Value]

FROM

     .....


talk is cheap, supply exceeds demand
sunny_talwar

Are you rounding them down to nearest 30 minutes?

May be this:

LOAD Time,

          Time(Floor(Time, (1/(24*2)))) as AssignValue -> my bad, Gysbert is right

          Time(Floor(Time, (1/(24*30)))) as AssignValue

FROM Source;

gauravgg
Partner - Creator
Partner - Creator
Author

Thanx

gauravgg
Partner - Creator
Partner - Creator
Author

Thanx

sunny_talwar

Please close the thread if you got what you were looking for by marking correct and helpful answer. Thanks

Qlik Community Tip: Marking Replies as Correct or Helpful

gauravgg
Partner - Creator
Partner - Creator
Author

hi

but for 8.00, 8.15, 8.30  it is assigning 8.00

it should not assign 8.30 to 8.00

MarcoWedel

‌please provide an example where the proposed expression converts 8.00 into 8.30

thanks

regards

Marco

gauravgg
Partner - Creator
Partner - Creator
Author

I have a column in which i have Time as follows

Time

12.00 AM

12.14 AM

13.12 AM

03.30 PM

04.00 PM

02.30 AM

12.30 AM

12.40 AM

.

.

.

n numbers of rows

I want to assign  it as following

Time                        Assign Value

12.00 AM                    12.00 AM

12.14 AM                    12.00 AM

13.12 AM                     13.00 AM

03.30 PM                     03.30 PM

04.00 PM                     04.00 AM

02.30 AM                     02.30 AM

12.30 AM                     12.30 AM

12.40 AM                      12.30 AM

.

n numbers of rows

sunny_talwar

Time component is in decimals so it is prone to rounding errors when you round, ceil or floor things. Check this link out where HIC talks about rounding error Rounding Errors‌.