topic Re: Converting measure into dimension in Qlik sense in App Development https://community.qlik.com/t5/App-Development/Converting-measure-into-dimension-in-Qlik-sense/m-p/15583#M1089 <HTML><HEAD></HEAD><BODY><P>Suggest you to transform your data in the script using <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Wed, 25 Apr 2018 12:46:10 GMT sunny_talwar 2018-04-25T12:46:10Z Converting measure into dimension in Qlik sense https://community.qlik.com/t5/App-Development/Converting-measure-into-dimension-in-Qlik-sense/m-p/15582#M1088 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have data given in below format, wherein it is monthly forecast from P1 (Jan) to P12 (Dec) and need to represent the same in Qlik sense Period wise P1, P2 ...... as chart shown below (excel charts as a reference)<SPAN style="font-size: 10pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="149" style="width: 676px; height: 92px;" width="731"><TBODY><TR><TD class="xl63" colspan="12" height="20" width="768">Monthly forecast</TD></TR><TR><TD class="xl64" height="20">P1</TD><TD class="xl64">P2</TD><TD class="xl64">P3</TD><TD class="xl64">P4</TD><TD class="xl64">P5</TD><TD class="xl64">P6</TD><TD class="xl64">P7</TD><TD class="xl64">P8</TD><TD class="xl64">P9</TD><TD class="xl64">P10</TD><TD class="xl64">P11</TD><TD class="xl64">P12</TD></TR><TR><TD align="right" height="20">488455.8</TD><TD align="right">440029</TD><TD align="right">441172.8</TD><TD align="right">441626.4</TD><TD align="right">450544.8</TD><TD align="right">456014.9</TD><TD align="right">380620.5</TD><TD align="right">438305</TD><TD align="right">461611.9</TD><TD align="right">476927.7</TD><TD align="right">461611.9</TD><TD align="right">438305</TD></TR><TR><TD align="right" height="20">746558.2</TD><TD align="right">1465887</TD><TD align="right">656513.9</TD><TD align="right">912060.3</TD><TD align="right">1062828</TD><TD align="right">902009.1</TD><TD align="right">771343.8</TD><TD align="right">932162.7</TD><TD align="right">922111.5</TD><TD align="right">1153289</TD><TD align="right">992469.7</TD><TD align="right">992469.7</TD></TR></TBODY></TABLE><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200736_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Apr 2018 09:21:15 GMT https://community.qlik.com/t5/App-Development/Converting-measure-into-dimension-in-Qlik-sense/m-p/15582#M1088 vinayvishwanath 2018-04-25T09:21:15Z Re: Converting measure into dimension in Qlik sense https://community.qlik.com/t5/App-Development/Converting-measure-into-dimension-in-Qlik-sense/m-p/15583#M1089 <HTML><HEAD></HEAD><BODY><P>Suggest you to transform your data in the script using <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Wed, 25 Apr 2018 12:46:10 GMT https://community.qlik.com/t5/App-Development/Converting-measure-into-dimension-in-Qlik-sense/m-p/15583#M1089 sunny_talwar 2018-04-25T12:46:10Z