0 Replies Latest reply: Jul 24, 2017 9:06 AM by Bill Markham RSS

    Set dimension display format in hypercube

    Bill Markham

      I am creating a hypercube as per the below and formatting the measure as a % using the Qlik num() function.  I am sure there must be a better way - Any ideas ?  

       

      app.createCube({

      qDimensions : [{

      qDef : { qFieldDefs : ["BU"] ,

      qSortCriterias: [{qSortByAscii: 1}]

      }},

      ],

      qMeasures: [

      {qDef: {qDef: "num($(vPercentTargetOTP15mtd),'#0.0%')",qLabel: "kpiBuMtdOtp15Target"}},

      ],

      qInitialDataFetch: [{qHeight: 40,qWidth: 44}]

      }

      ,arrayBuMtdKpi);