1 Reply Latest reply: Jan 22, 2018 8:27 AM by silambarasan HR RSS

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

    silambarasan HR

      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

        • Re: Mashup using DateRangePicker Exten, get calender and how we can get the start date and End date
          silambarasan HR

          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