Published
Edited
Jun 23, 2020
Insert cell
Insert cell
Insert cell
Insert cell
engineApiAppPromise = {
const { qdtEnigma } = QdtComponents;
const config = {
host: 'sense-demo.qlik.com',
secure: true,
port: 443,
prefix: '',
appId: '133dab5d-8f56-4d40-b3e0-a6b401391bde', // Helpdesk
};
return qdtEnigma(config);
}
Insert cell
app = await engineApiAppPromise;
Insert cell
{
const { qdtCompose, QdtTable } = QdtComponents;
qdtCompose({
element,
component: QdtTable,
app,
options: { multiple: false },
properties: {
qHyperCubeDef: {
qDimensions: [
{
qDef: { qLabel: 'Case Number', qFieldDefs: ['CaseNumber'] },
},
{
qDef: { qLabel: 'Subject', qFieldDefs: ['Subject'] },
},
{
qDef: { qLabel: 'Case Owner', qFieldDefs: ['Case Owner'] },
},
{
qDef: { qLabel: 'Status', qFieldDefs: ['Status'] },
},
{
qDef: { qLabel: 'Case Created Date', qFieldDefs: ['Case Created Date'] },
},
{
qDef: { qLabel: 'Case Closed Date', qFieldDefs: ['Case Closed Date'] },
},
],
qMeasures: [
{
qDef: {
qLabel: 'Case Duration (dd hh:mm)',
qDef: "If(Count({$<[Case Is Closed]={'True'} >} %CaseId)>0, Avg ([Case Duration Time]),0)+ If(Count({$<[Case Is Closed]={'False'} >} %CaseId)>0, Avg([Case Aging]), 0)",
qNumFormat: { qType: 'D', qFmt: 'dd hh:mm' },
},
qSortBy: { qSortByNumeric: -1 },
},
],
},
}
});
}
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more