topic Re: Loop in calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Loop-in-calculated-Dimension/m-p/899540#M312977 <HTML><HEAD></HEAD><BODY><P>I don't understand what you're trying to do. Can you post a file with example source data and a file with the result table you expect?</P></BODY></HTML> Thu, 21 May 2015 08:56:27 GMT Gysbert_Wassenaar 2015-05-21T08:56:27Z Loop in calculated Dimension https://community.qlik.com/t5/QlikView/Loop-in-calculated-Dimension/m-p/899539#M312976 <HTML><HEAD></HEAD><BODY><P> Hello</P><P><SPAN class="hps">I'm trying</SPAN> <SPAN class="hps">to split</SPAN> <SPAN class="hps">a dimension</SPAN> <SPAN class="hps">using the</SPAN> <SPAN class="hps">function</SPAN> <SPAN class="hps">SubField in Pivot Table</SPAN></P><P><SPAN class="hps">For example:</SPAN></P><P>ItemName_Concatenated=<SPAN class="hps">A</SPAN> <SPAN class="hps">|</SPAN> <SPAN class="hps">B</SPAN> <SPAN class="hps">|</SPAN> <SPAN class="hps">C</SPAN> <SPAN class="hps">|</SPAN> <SPAN class="hps">D</SPAN></P><P><SPAN class="hps">(BarcodeCount</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">number of elements</SPAN> <SPAN class="hps">in the chain=4)</SPAN></P><P><SPAN class="hps">= SubField (ItemName_Concatenated, '|', BarcodeCount)</SPAN></P><P><SPAN class="hps">Appears</SPAN> <SPAN class="hps">as a dimension</SPAN></P><P><SPAN class="hps">I am able to</SPAN> <SPAN class="hps">do this only</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">one</SPAN> <SPAN class="hps">of the letters</SPAN> <SPAN class="hps">at a time</SPAN>.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ItemName</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>A</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>B</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>C</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>D</STRONG></TH></TR><TR><TD>a</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD style="padding: 2px;">b</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">c</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">d</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">e</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD>f</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P><SPAN class="hps">Is there</SPAN> <SPAN class="hps">a way to</SPAN> <SPAN class="hps">loop</SPAN> <SPAN class="hps">the calculated</SPAN> <SPAN class="hps">dimension</SPAN>?</P></BODY></HTML> Wed, 20 May 2015 15:18:52 GMT https://community.qlik.com/t5/QlikView/Loop-in-calculated-Dimension/m-p/899539#M312976 danishar 2015-05-20T15:18:52Z Re: Loop in calculated Dimension https://community.qlik.com/t5/QlikView/Loop-in-calculated-Dimension/m-p/899540#M312977 <HTML><HEAD></HEAD><BODY><P>I don't understand what you're trying to do. Can you post a file with example source data and a file with the result table you expect?</P></BODY></HTML> Thu, 21 May 2015 08:56:27 GMT https://community.qlik.com/t5/QlikView/Loop-in-calculated-Dimension/m-p/899540#M312977 Gysbert_Wassenaar 2015-05-21T08:56:27Z