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: 
datanibbler
Champion
Champion

Do I need quotes or none or ...


Hi,

actually, what I'm trying to do in this step is very easy:

- I have a list of bookings from our Database that were done on one specific box.

- Each of those bookings has a date-time-stamp

- I have one date-time-stamp and I want to get all bookings on that box that were done before
  => To be able to compare it, I have put the numeric equivalent of that date-time-stamp into a variable
  => In the next LOAD I `have included a WHERE clause, specifying that num([date-time-stamp]) < '$([variable])'

However, that doesn't work: I do get some bookings - but including the one with that date-time-stamp and that name - I wanted to exclude that and get only those that were done strictly before that (operator < )

=> I thought that it might be because of the quotes and I removed them

=> Then the log said "Garbage after statement"

I post here the last few lines from the log so you know what I am talking about.

16.12.2014 11:17:52: 0600  NoConcatenate
16.12.2014 11:17:52: 0601  Trans_Dtl2:
16.12.2014 11:17:52: 0602  LOAD
16.12.2014 11:17:52: 0603      Tran_Date_v1 as Tran_Date_v4,
16.12.2014 11:17:52: 0604      User_Signon_v1 as User_Signon_v4,
16.12.2014 11:17:52: 0605      Tracking_Nr_v1 as Track_Nr_v4,
16.12.2014 11:17:52: 0606      QUANTITY as Qty_v4
16.12.2014 11:17:52: 0607  RESIDENT Transaction_Details_pre
16.12.2014 11:17:52: 0608  WHERE Tracking_Nr_v1 = 'B3D254'
16.12.2014 11:17:52: 0609  AND num(Tran_Date_v1) < 41974,27712963

16.12.2014 11:17:52:        4 fields found: Tran_Date_v4, User_Signon_v4, Track_Nr_v4, Qty_v4, 1 lines fetched
16.12.2014 11:17:54:       Error: Garbage after statement
16.12.2014 11:17:54:       General Script Error
16.12.2014 11:17:54:       Execution Failed
16.12.2014 11:17:54:      Execution finished.

Can anybody help me there?

Best regards,

DataNibbler

1 Solution

Accepted Solutions
marcus_sommer

Hi DataNibbler,

I think it's the comma in num(Tran_Date_v1) < 41974,27712963 - use instead a point num(Tran_Date_v1) < 41974.27712963

- Marcus

View solution in original post

4 Replies
Anonymous
Not applicable

Could you share the whole of the load statement and a few statements after that as well ?

marcus_sommer

Hi DataNibbler,

I think it's the comma in num(Tran_Date_v1) < 41974,27712963 - use instead a point num(Tran_Date_v1) < 41974.27712963

- Marcus

datanibbler
Champion
Champion
Author

Hi Marcus,

that is placed automatically based on that SET command on the Main tab, no? So I'll have to replace it.

Thanks a lot!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

You could replace the '$([variable])' part with something like num#('$([variable])'). Should handle the different format....

Peter