topic Re: Qlik Server vs Desktop in QlikView

Qlik Server vs Desktop

Thu, 19 Mar 2015 15:47:02 GMT

Question - We have a qlikview server in Germany that another team manages. I developed a dashboard on my local computer and sent them the qvw and qvd files to upload which they have done many times for me before without any hitches. This time my dashboard was a little more complex and had the below routine to generate a calendar and then another line to create a common calendar. This worked with no issues on my local copy but the published version shows no results.

Anyone have any ideas why it would be different on the server vs a local version of qlik?

//===================================================

// Subroutine to Generate Calendar.

//===================================================

SUB CalendarFromField(_field, _calendar, _prefix)

[$(_calendar)]:

// Generate Final Calendar

LOAD

[$(_field)]

,year([$(_field)]) as [$(_prefix)Year]

,month([$(_field)]) as [$(_prefix)Month]

,day([$(_field)]) as [$(_prefix)Day]

,weekday([$(_field)]) as [$(_prefix)Weekday]

;

// Generate range of dates between min and max.

LOAD

date(DateMin + IterNo()) as [$(_field)] // Link Field

WHILE DateMin + IterNo() <= DateMax

;

// Find min and max of date field values.

LOAD

min(datefield)-1 as DateMin

,max(datefield) as DateMax

;

// Load date field values.

LOAD

FieldValue('$(_field)', RecNo()) as datefield

AutoGenerate FieldValueCount('$(_field)');

END SUB

Then CALL CalendarFromField('Date', 'CommonCalendar', ''); to generate the the actual "Common calendar"

Re: Qlik Server vs Desktop

Gysbert_Wassenaar — Thu, 19 Mar 2015 17:28:45 GMT

but the published version shows no results.

Perhaps the previous version is still loaded in memory? Did you reload the document?

Re: Qlik Server vs Desktop

Thu, 19 Mar 2015 19:42:37 GMT

I did reload the document once published to the server. If you go to the table view and look at the common calendar table it shows no data on the server except the date field in mm/yyyy format but on the local copy it does separate the mm/yyyy into Month names and year numbers.

Re: Qlik Server vs Desktop

Gysbert_Wassenaar — Fri, 20 Mar 2015 08:37:06 GMT

Just to be sure, do your two copies load from exactly the same source files and tables?

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:11:21 GMT

Yes they both load from the same source. They both pull the dates into the date MM/YYYY format but on the server the script above seems to not strip the month numbers out as month names and the years do not populate either.

Re: Qlik Server vs Desktop

Peter_Cammaert — Fri, 20 Mar 2015 12:23:07 GMT

Servers and Desktop/Laptop machines may have different system settings to represent date & time values. In a QlikView script, both are usually set to a fixed value. Is that also the case in the two environments? Are there anyconflicts between date/time values you get from the OS?

Peter

Re: Qlik Server vs Desktop

Gysbert_Wassenaar — Fri, 20 Mar 2015 12:26:18 GMT

Does the document use any include statements for script code that is loaded from external files? The subroutine you posted looks like part of the Qlikview Components library. If code is loaded with include statements can these files be found in the same place on the server as on your local computer?

Are the MM/YYYY dates real dates in both documents? Or does the server copy contain text values in that field?

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:31:11 GMT

So I am still a newbie to Qlik, I am getting better but still a newb.

On the Server these are the set functions that I thought drove that stuff.

let project = 'IT_Segment';

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Then on the client side it looks like this.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Both are the same except for the "let project" statement. Other than that the only difference to date and time looks to be the time zone.

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:34:17 GMT

No I do not have any include statements in either document. I got that subroutine from a qlikview post talking about conical dates and it helped me create that common calendar.

Yes both dates are real, they are gathered from about 6 different tables..

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:45:02 GMT

You know, maybe I over thought this whole thing. I pull all the dates into another table called "Date Link" and then this sub routine was used so that I could generate this table called "Common Calendar" but TBH I really do not understand exactly what it does. Now I am thinking I could get away with the following. Just adding Year(Date) as Year and then Month(Date) as Month seems to give me the exact same results...All of the dates are pulled into the date link and at least I understand what this is doing....

It still does not explain what is the difference between the server side and the client side but I have a meeting scheduled with the qlik admin on Monday and if we can isolate the issue I will post the resolution on here.

Directory;

LOAD Segment,

Date,

DateType,

Year(Date) as Year,

Month(Date) as Month

FROM

Datelink.qvd

(qvd);

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:51:10 GMT

It's the first time that you user VBA Macros in Qlikview? Did you allow macro execution on the server?

Re: Qlik Server vs Desktop

awhitfield — Fri, 20 Mar 2015 12:51:58 GMT

Could it be that the date formats differ between the Local PC and The Germany based server:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0;-£#,##0';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:55:02 GMT

Ok so again I am a newb here. Is that subroutine a VBA script? Either way I do not know if macro execution is allowed on the server but that is a good idea. I will make sure to ask that on Monday.

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 12:56:12 GMT

I looked at the time settings on the server and compared them to my PC, they are exactly the same for the the time zone, I am UTC -5 or something and they are UTC -1 or something like that but dates are displayed in the same format.

Re: Qlik Server vs Desktop

Gysbert_Wassenaar — Fri, 20 Mar 2015 12:58:35 GMT

What the subroutine does it create a calendar table with all the dates spanning the interval between the minimum and maximum date in your Datelink.qvd file. That calendar table will have no gaps. Your source data could have missing dates, i.e. gaps in the calendar. But if you know that there are no gaps then you might as well use the Month() and Year() functions directly as you posted above.

Re: Qlik Server vs Desktop

Fri, 20 Mar 2015 13:09:43 GMT

Ask for your Server Administrador to look for Server Settings in the QMC (Management Console). There are items to configure macro execution on there.

Look this picture

I believe that is under QMC -> System -> Servers -> QVS

Good luck

Re: Qlik Server vs Desktop

Gysbert_Wassenaar — Fri, 20 Mar 2015 13:13:02 GMT

The subroutine he posted is not macro code.