topic Loading descriptions in different formats into labels in QlikView https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392139#M1161938 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P></P><P>I have tried Mapping with wildcards from the QV Cookbook <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> (</SPAN><A class="jive-link-external-small" href="http://robwunderlich.com/downloads/" style="color: #007fc0; font-family: Arial; background-color: #ffffff;">http://robwunderlich.com/downloads/</A><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">)&nbsp; example "Mapping with a table using wildcards" .</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">This works perfect for a few lines, but If I want to use it for more than approx 10 statements than it's not working anymore. </SPAN></P><P></P><P></P><P>It's for using in a qwv for bankstatements. The used discription is always mixed in length, place of the needed part and use of numbers and letters. Eg</P><P></P><P><STRONG>Descriptions:</STRONG></P><P>1256 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp; </P><P>1 NEXT FIRM 55663</P><P>PLACE 69.12.63</P><P></P><P><STRONG>I want to have then:</STRONG></P><P>Descriptions:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Key:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label3</P><P>1256 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *SUPER*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BREAD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyA</P><P>1299 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *SUPER*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BREAD&nbsp;&nbsp;&nbsp;&nbsp; Company A</P><P>1 NEXT FIRM 55663&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *FIRM*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MEAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyB</P><P>PLACE 69.12.63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *69.12*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyC</P><P></P><P>Etc etc for many (approx 100) descriptions.</P><P></P><P>Then in the dashboard I want to see eg all "BREAD" or "Company A".</P><P></P><P>Anyone have a solution? Maybe a loop?</P></BODY></HTML> Thu, 01 Nov 2012 13:13:51 GMT 2012-11-01T13:13:51Z Loading descriptions in different formats into labels https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392139#M1161938 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P></P><P>I have tried Mapping with wildcards from the QV Cookbook <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> (</SPAN><A class="jive-link-external-small" href="http://robwunderlich.com/downloads/" style="color: #007fc0; font-family: Arial; background-color: #ffffff;">http://robwunderlich.com/downloads/</A><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">)&nbsp; example "Mapping with a table using wildcards" .</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">This works perfect for a few lines, but If I want to use it for more than approx 10 statements than it's not working anymore. </SPAN></P><P></P><P></P><P>It's for using in a qwv for bankstatements. The used discription is always mixed in length, place of the needed part and use of numbers and letters. Eg</P><P></P><P><STRONG>Descriptions:</STRONG></P><P>1256 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp; </P><P>1 NEXT FIRM 55663</P><P>PLACE 69.12.63</P><P></P><P><STRONG>I want to have then:</STRONG></P><P>Descriptions:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Key:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label3</P><P>1256 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *SUPER*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BREAD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyA</P><P>1299 SUPER 56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *SUPER*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BREAD&nbsp;&nbsp;&nbsp;&nbsp; Company A</P><P>1 NEXT FIRM 55663&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *FIRM*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FOOD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MEAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyB</P><P>PLACE 69.12.63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *69.12*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BANK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CompanyC</P><P></P><P>Etc etc for many (approx 100) descriptions.</P><P></P><P>Then in the dashboard I want to see eg all "BREAD" or "Company A".</P><P></P><P>Anyone have a solution? Maybe a loop?</P></BODY></HTML> Thu, 01 Nov 2012 13:13:51 GMT https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392139#M1161938 2012-11-01T13:13:51Z Re: Loading descriptions in different formats into labels https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392140#M1161939 <HTML><HEAD></HEAD><BODY><P>Does qlikview components have the same limitations as the QV cookbook?</P><P></P><P>If you don't know I'll suggest you give it a try.</P><P><SPAN>You'll find it here: </SPAN><A class="jive-link-external-small" href="http://qlikviewcomponents.org/">http://qlikviewcomponents.org/</A></P><P></P><P></P><P>Best regards</P><P>Vegar Lie Arntsen</P><P><SPAN>QlikView consultant at egbs consulting ab </SPAN><A class="jive-link-external-small" href="http://egbs.se">http://egbs.se</A></P><P><SPAN>Blog (in Swedish): </SPAN><A class="jive-link-external-small" href="http://bi-effekten.se">http://bi-effekten.se</A></P></BODY></HTML> Thu, 01 Nov 2012 19:59:25 GMT https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392140#M1161939 Vegar 2012-11-01T19:59:25Z Re: Loading descriptions in different formats into labels https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392141#M1161940 <HTML><HEAD></HEAD><BODY><P>I do not really understand your reply, the qlikview components are examples, right? I do not really know where to look for the thing I need. </P><P></P><P>In excel it is not really feasible, in Acces it can be done, so I guess in QV it should be extremely difficult, but apparently it is...</P><P></P><P>Anyone an idea?</P></BODY></HTML> Mon, 05 Nov 2012 07:12:58 GMT https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392141#M1161940 2012-11-05T07:12:58Z Re: Loading descriptions in different formats into labels https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392142#M1161941 <HTML><HEAD></HEAD><BODY><P>No, QVC is not just a bunch of examples. It is a open source script-library initiated and maintained by <A href="https://community.qlik.com/qlik-users/2286">Rob Wunderlich</A>.</P><P>I find it usefull to use for example when doing just wildmatches and when importing variables from a flat file. </P><P></P><P>Take a look at my attached example. </P><P>To run the script yourself you need to download <A href="http://code.google.com/p/qlikview-components/downloads/list">QlikView Components</A> and adjust the include search path.</P><P></P><P>NB: I have not checked if it will run smoothly on 100+ descriptions.</P><P></P><P></P><P>Best regards</P><P><A href="https://community.qlik.com/qlik-users/100292">Vegar Lie Arntsen</A></P><P><EM>QlikView consultant at </EM><A href="http://bit.ly/PoSwU2">egbs consulting ab</A></P><P><EM>Blog (in Swedish):</EM> <A href="http://bit.ly/UkXdvt">bi-effekten.se</A></P></BODY></HTML> Tue, 06 Nov 2012 08:25:55 GMT https://community.qlik.com/t5/QlikView/Loading-descriptions-in-different-formats-into-labels/m-p/392142#M1161941 Vegar 2012-11-06T08:25:55Z