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: 
FernandaNava
Partner - Contributor III
Partner - Contributor III

Min() Max() returning multiple values

I'm using a standard code  http://community.qlik.com/thread/48693

to create a master calendar, but I'm getting a strange error. Apparently the functions Min() and Max() are not returning a numeric value but a string of two values separated by a comma:

 

Captureww.PNG

 

And so the operation can't continue because it's expecting a numeric value. I've already checked that the dates are being loaded correctly. I'm even able to do Min(date) or Max(date) in a text box when creating a dashboard and it works properly. 

I've used these functions and data before and I had never encountered a problem like this one. Anyone has experienced this problem?

Labels (4)
1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

Looks like regional settings

What do you have in your load script as decimal separator?

SET DecimalSep='.';

View solution in original post

4 Replies
lorenzoconforti
Specialist II
Specialist II

How does your date field looks like when you check its properties in the data model viewer?

FernandaNava
Partner - Contributor III
Partner - Contributor III
Author

Ok apparently here it says numeric timestamp, so why does it look like this?

 

Captureff.PNG

lorenzoconforti
Specialist II
Specialist II

Looks like regional settings

What do you have in your load script as decimal separator?

SET DecimalSep='.';

FernandaNava
Partner - Contributor III
Partner - Contributor III
Author

That was it! My computer has Americas regional settings but I had changed the separator since I'm working for an European project right now.

 

Thank you!