Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combo-chart problem

Hi all, could anybody help me with this problem:

lerror loading image



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;


0 Replies