Reloading

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

please help with this below:

Calendar:

LOAD DISTINCT

DATE,

YEAR(ADDMONTHS(DATE,3)) AS Year,

YEAR(DATE) AS [CALENDAR YEAR],

MONTH(ADDMONTHS(DATE,3)) AS Month,

LEFT(month(addmonths(DATE,3)),3)& '-'& YEAR(DATE) AS [MONTH YEAR],

LEFT(MONTH(ADDMONTHS(DATE,3)),3)& ' | '& DAY(DATE)&'-'& WEEKDAY(DATE) AS [DAY OF MONTH],

DAY(DATE)AS [DAY],

DATE(MONTHSTART(ADDMONTHS(DATE,3)), 'MMM-YYYY') AS YearMonth,

'Q'&CEIL(MONTH(ADDMONTHS(DATE,3))/3) AS Quarter,

WEEK(DATE) AS Week

RESIDENT data;

Let vReloadTimeComplete = Now();

// Google Maps in QlikView

// V0.85.2 - October 1st 2008 © Copyright QlikTech International AB 2008 / AES

// Google Maps Key

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

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

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

SET DateFormat='YYYYMMDD';

SET TimestampFormat='YYYYMMDD h:mm:ss[.fff] TT';

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

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

// get a key here http://code.google.com/apis/maps/signup.html

gmap_key = 'xx';

max_zoom_level = 17; //maximum value 17

// Variables required for calculating map

// No need to change these

var_pi180= '=pi()/180';

var_lat_offset= '0';

var_long_offset = '0' ;

var_mc2= '=256*pow(2,$(var_zoom))';

var_mc1= '=256*pow(2,($(var_zoom)-1))';

var_mid_lat= '=min(Latitude)+(1+var_lat_offset)*((max(Latitude)-min(Latitude))/2)';

var_mid_long= '=min(Longitude)+(max(Longitude)-min(Longitude))/2';

var_zoom= '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';

var_maptype= '=if(isnull(only(maptype)),fieldvalue( '& CHR(39)&'maptype'& CHR(39)&', 1 ),maptype)';

map_size_x= '640';

map_size_y= '400';

SET HidePrefix='_' ;

// Field required for calcualting best zoom level

_zoom_level:

LOAD RecNo() AS _zoom_level AutoGenerate(max_zoom_level);

maptype:

LOAD * INLINE [

maptype

roadmap

mobile

satellite

terrain

hybrid];

The error am getting out of this :

Table not found
Calendar:
LOAD DISTINCT
DATE,
YEAR(ADDMONTHS(DATE,3)) AS Year,
YEAR(DATE) AS [CALENDAR YEAR],
MONTH(ADDMONTHS(DATE,3)) AS Month,
LEFT(month(addmonths(DATE,3)),3)& '-'& YEAR(DATE) AS [MONTH YEAR],
LEFT(MONTH(ADDMONTHS(DATE,3)),3)& ' | '& DAY(DATE)&'-'& WEEKDAY(DATE) AS [DAY OF MONTH],
DAY(DATE)AS [DAY],
DATE(MONTHSTART(ADDMONTHS(DATE,3)), 'MMM-YYYY') AS YearMonth,
'Q'&CEIL(MONTH(ADDMONTHS(DATE,3))/3) AS Quarter,
WEEK(DATE) AS Week

RESIDENT data

Thank you,

Treasure

Re: Reloading

Clever_Anjos — Wed, 20 Jul 2016 13:54:30 GMT

Would you mind posting your entire script?

We need to check if there´s a table called "data" before the first LOAD

Re: Reloading

Tue, 30 Aug 2016 12:47:20 GMT

Hi clever, am now sorted with this, Thanks

Re: Reloading

Clever_Anjos — Tue, 30 Aug 2016 12:52:08 GMT

Did you fix the issue?

Please mark it as assumered answered or mark one answer as "Correct" to close the case

topic Re: Reloading in QlikView

Reloading

Re: Reloading

Re: Reloading

Re: Reloading