https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Chart-level-scripts-PUT-DimensionName-r-does-not-work/ta-p/2479152 <P><EM>The conclusions in this article were reached in collaboration with&nbsp;<A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/106375" target="_blank" rel="noopener">cjgorrin</A> from the European Commission's Joint Research Centre Qlik Sense team.</EM></P> <P>Based on Qlik Sense online documentation, a PUT statement can be used to access columns, rows i.e. to set a numeric value to the hypercube.</P> <P>However, using a Dimension name in a PUT statement, the following error is thrown:</P> <P class="lia-indent-padding-left-30px"><FONT face="courier new,courier">Load statement could not find target column [MyDim1] in hypercube</FONT></P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="put dimensionname error.png" style="width: 955px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171190i43AB2DF8EB763DCE/image-size/large?v=v2&amp;px=999" role="button" title="put dimensionname error.png" alt="put dimensionname error.png" /></span></P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>This is working as designed.</P> <P><FONT color="#339966"><STRONG>Put statements</STRONG></FONT><SPAN>&nbsp;</SPAN>are not allowed to manipulate dimensions. The Qlik Sense online help will be updated to reflect this.&nbsp;</P> <H3 id="toc-hId-254220046"><STRONG><FONT color="#339966">Internal Investigation ID(s):</FONT></STRONG></H3> <P class="lia-indent-padding-left-30px">QB-27904</P> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Sense May 2024 and above</LI> <LI>Qlik Sense Cloud</LI> </UL> Thu, 05 Sep 2024 08:01:06 GMT Joseph_Musekura 2024-09-05T08:01:06Z https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Chart-level-scripts-PUT-DimensionName-r-does-not-work/ta-p/2479152 <P><EM>The conclusions in this article were reached in collaboration with&nbsp;<A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/106375" target="_blank" rel="noopener">cjgorrin</A> from the European Commission's Joint Research Centre Qlik Sense team.</EM></P> <P>Based on Qlik Sense online documentation, a PUT statement can be used to access columns, rows i.e. to set a numeric value to the hypercube.</P> <P>However, using a Dimension name in a PUT statement, the following error is thrown:</P> <P class="lia-indent-padding-left-30px"><FONT face="courier new,courier">Load statement could not find target column [MyDim1] in hypercube</FONT></P> <P class="lia-indent-padding-left-30px"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="put dimensionname error.png" style="width: 955px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171190i43AB2DF8EB763DCE/image-size/large?v=v2&amp;px=999" role="button" title="put dimensionname error.png" alt="put dimensionname error.png" /></span></P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>This is working as designed.</P> <P><FONT color="#339966"><STRONG>Put statements</STRONG></FONT><SPAN>&nbsp;</SPAN>are not allowed to manipulate dimensions. The Qlik Sense online help will be updated to reflect this.&nbsp;</P> <H3 id="toc-hId-254220046"><STRONG><FONT color="#339966">Internal Investigation ID(s):</FONT></STRONG></H3> <P class="lia-indent-padding-left-30px">QB-27904</P> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Sense May 2024 and above</LI> <LI>Qlik Sense Cloud</LI> </UL> Thu, 05 Sep 2024 08:01:06 GMT https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Chart-level-scripts-PUT-DimensionName-r-does-not-work/ta-p/2479152 Joseph_Musekura 2024-09-05T08:01:06Z