topic Set dimension display format in hypercube in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Set-dimension-display-format-in-hypercube/m-p/1359870#M7900 <HTML><HEAD></HEAD><BODY><P>I am creating a hypercube as per the below and formatting the measure as a % using the Qlik num() function.&nbsp; I am sure there must be a better way - Any ideas ?&nbsp;&nbsp; </P><P></P><P style="padding-left: 30px;">app.createCube({</P><P style="padding-left: 60px;">qDimensions : [{</P><P style="padding-left: 90px;">qDef : { qFieldDefs : ["BU"] ,</P><P style="padding-left: 90px;">qSortCriterias: [{qSortByAscii: 1}]</P><P style="padding-left: 60px;">}}, </P><P style="padding-left: 60px;">],</P><P style="padding-left: 60px;"> qMeasures: [</P><P style="padding-left: 90px;">{qDef: {qDef: "<SPAN style="color: #993300;"><STRONG>num(</STRONG></SPAN>$(vPercentTargetOTP15mtd)<STRONG style="color: #993300;">,'#0.0%')</STRONG>",qLabel: "kpiBuMtdOtp15Target"}},</P><P style="padding-left: 60px;">],</P><P style="padding-left: 60px;">qInitial<SPAN style="font-size: 10pt;">DataFetch: [{qHeight: 40,qWidth: 44}]</SPAN></P><P style="padding-left: 60px;">}</P><P style="padding-left: 30px;">,arrayBuMtdKpi);</P></BODY></HTML> Mon, 24 Jul 2017 13:06:19 GMT Anonymous 2017-07-24T13:06:19Z Set dimension display format in hypercube https://community.qlik.com/t5/Integration-Extension-APIs/Set-dimension-display-format-in-hypercube/m-p/1359870#M7900 <HTML><HEAD></HEAD><BODY><P>I am creating a hypercube as per the below and formatting the measure as a % using the Qlik num() function.&nbsp; I am sure there must be a better way - Any ideas ?&nbsp;&nbsp; </P><P></P><P style="padding-left: 30px;">app.createCube({</P><P style="padding-left: 60px;">qDimensions : [{</P><P style="padding-left: 90px;">qDef : { qFieldDefs : ["BU"] ,</P><P style="padding-left: 90px;">qSortCriterias: [{qSortByAscii: 1}]</P><P style="padding-left: 60px;">}}, </P><P style="padding-left: 60px;">],</P><P style="padding-left: 60px;"> qMeasures: [</P><P style="padding-left: 90px;">{qDef: {qDef: "<SPAN style="color: #993300;"><STRONG>num(</STRONG></SPAN>$(vPercentTargetOTP15mtd)<STRONG style="color: #993300;">,'#0.0%')</STRONG>",qLabel: "kpiBuMtdOtp15Target"}},</P><P style="padding-left: 60px;">],</P><P style="padding-left: 60px;">qInitial<SPAN style="font-size: 10pt;">DataFetch: [{qHeight: 40,qWidth: 44}]</SPAN></P><P style="padding-left: 60px;">}</P><P style="padding-left: 30px;">,arrayBuMtdKpi);</P></BODY></HTML> Mon, 24 Jul 2017 13:06:19 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Set-dimension-display-format-in-hypercube/m-p/1359870#M7900 Anonymous 2017-07-24T13:06:19Z