Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Mashup using DateRangePicker Exten, get calender and how we can get the start date and End date value in using mashup?
we using DateRangePicker Extension:
mashup how we can get date difference ?
Answer : We can use Hyper Cub we can get the details
app.createCube({
"qInitialDataFetch": [
{
"qHeight": 20,
"qWidth": 1
}
],
"qDimensions": [],
"qMeasures": [
{
"qDef": {
"qDef": "=Date(max([%Date]))-Date(min([%Date]))"
},
"qLabel": "=Date(max([%Date]))-Date(min([%Date]))",
"qLibraryId": null,
"qSortBy": {
"qSortByState": 0,
"qSortByFrequency": 0,
"qSortByNumeric": 0,
"qSortByAscii": 1,
"qSortByLoadOrder": 0,
"qSortByExpression": 0,
"qExpression": {
"qv": " "
}
}
}
],
"qSuppressZero": false,
"qSuppressMissing": false,
"qMode": "S",
"qInterColumnSortOrder": [],
"qStateName": "$"
}, load_data);
function load_data(reply, app) {
console.log("calculated value");
var days = reply.qHyperCube.qDataPages[0].qMatrix[0][0].qText;
console.log("output");
console.log(days);
}
var days In the variable we can get the date differance from start date and end date
Answer : We can use Hyper Cub we can get the details
app.createCube({
"qInitialDataFetch": [
{
"qHeight": 20,
"qWidth": 1
}
],
"qDimensions": [],
"qMeasures": [
{
"qDef": {
"qDef": "=Date(max([%Date]))-Date(min([%Date]))"
},
"qLabel": "=Date(max([%Date]))-Date(min([%Date]))",
"qLibraryId": null,
"qSortBy": {
"qSortByState": 0,
"qSortByFrequency": 0,
"qSortByNumeric": 0,
"qSortByAscii": 1,
"qSortByLoadOrder": 0,
"qSortByExpression": 0,
"qExpression": {
"qv": " "
}
}
}
],
"qSuppressZero": false,
"qSuppressMissing": false,
"qMode": "S",
"qInterColumnSortOrder": [],
"qStateName": "$"
}, load_data);
function load_data(reply, app) {
console.log("calculated value");
var days = reply.qHyperCube.qDataPages[0].qMatrix[0][0].qText;
console.log("output");
console.log(days);
}
var days In the variable we can get the date differance from start date and end date