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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hrsimbu87
Partner - Contributor II
Partner - Contributor II

Mashup using DateRangePicker Exten, get calender and how we can get the start date and End date

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 ?

calender.png

1 Solution

Accepted Solutions
hrsimbu87
Partner - Contributor II
Partner - Contributor II
Author

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


View solution in original post

1 Reply
hrsimbu87
Partner - Contributor II
Partner - Contributor II
Author

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