Combo-chart problem

Fri, 30 Oct 2009 20:03:05 GMT

Hi all, could anybody help me with this problem:



LogOnOff:
odbc connect to ...
load date(DDATE_LOGON, 'DD.MM.YYYY hh:mm:ss') as DDATE_LOGON,
 date(DDATE_LOGOFF, 'DD.MM.YYYY hh:mm:ss') as DDATE_LOGOFF,
 SAUTHID as SAUTHID,
 SPROGRAM as SPROGRAM,
 NRN as NRN
 ;
SQL SELECT *
FROM PARUS."UDO_V_LOGONOFF";

AppList:
ODBC CONNECT TO ...
load APPCODE as SPROGRAM,
 APPNAME as SAPPNAME
 ;
sql select *
from PARUS."V_APPLIST";

TimeStamps:
replace
load date('$(varCrntDate)' + recno()/24/4, 'DD.MM.YYYY hh:mm:ss') as DateTimeStamp
autogenerate(95);

replace
intervalmatch(DateTimeStamp) load DDATE_LOGON, DDATE_LOGOFF resident LogOnOff;


BpHist:
odbc connect to ...
//noconcatenate
load date(REG_DATE, 'DD.MM.YYYY hh:mm:ss') as DREG_DATE,
 date(END_DATE, 'DD.MM.YYYY hh:mm:ss') as DEND_DATE,
 RESULT as NRESULT,
 UNITCODE as SUNITCODE,
 ACTION as SACTION,
 AUTHID as SAUTHID,
 PROGRAM as SPROGRAM,
 RN as NRN_BPHIST
 ;
sql select *
from PARUS."BPHIST"
where REG_DATE >= trunc(sysdate);

TimeIntervals:
replace
load previous(DateTimeStamp) as TimeIntrvlBegin,
 DateTimeStamp as TimeIntrvlEnd
resident TimeStamps
where IsNull(previous(DateTimeStamp)) = 0;

replace
intervalmatch (DREG_DATE) load TimeIntrvlBegin, TimeIntrvlEnd resident TimeIntervals;

topic Combo-chart problem in QlikView

Combo-chart problem