Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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?

1 Solution

Accepted Solutions
Highlighted
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
Highlighted
Specialist II
Specialist II

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

Highlighted
Partner
Partner

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

 

Captureff.PNG

Highlighted
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

Highlighted
Partner
Partner

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!