Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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?
Looks like regional settings
What do you have in your load script as decimal separator?
SET DecimalSep='.';
How does your date field looks like when you check its properties in the data model viewer?
Ok apparently here it says numeric timestamp, so why does it look like this?
Looks like regional settings
What do you have in your load script as decimal separator?
SET DecimalSep='.';
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!