topic Re: Key field in QlikView https://community.qlik.com/t5/QlikView/Key-field/m-p/1133117#M910564 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P>Try this:</P><P>SubField(</P><P>&nbsp;&nbsp;&nbsp; SUBFIELD(Parent</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child1)&gt;0,'#'&amp;Child1)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child2)&gt;0,'#'&amp;Child2)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child3)&gt;0,'#'&amp;Child3)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child4)&gt;0,'#'&amp;Child4),'#',</P><P>&nbsp;&nbsp;&nbsp; SubStringCount(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child1)&gt;0,'#'&amp;Child1)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child2)&gt;0,'#'&amp;Child2)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child3)&gt;0,'#'&amp;Child3)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child4)&gt;0,'#'&amp;Child4),'#')+1),'-',1)</P><P></P><P>Regards!</P></BODY></HTML> Thu, 16 Jun 2016 15:09:59 GMT Anonymous 2016-06-16T15:09:59Z Key field https://community.qlik.com/t5/QlikView/Key-field/m-p/1133113#M910560 <HTML><HEAD></HEAD><BODY><P>hi Community,</P><P></P><P>I wanted to create a <SPAN style="font-size: 14pt;">key</SPAN> based on some fileds like below.</P><P></P><P>EX:</P><P></P><P><STRONG>Data:</STRONG></P><P>Parent&nbsp;&nbsp; Child1&nbsp;&nbsp; Child2&nbsp;&nbsp; Child3&nbsp;&nbsp; Child4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Key - We need to create like below</STRONG></P><P>12-CX&nbsp;&nbsp; D1-39&nbsp;&nbsp; 4R-8Y&nbsp;&nbsp; <SPAN style="font-size: 14pt;"><STRONG>Y5</STRONG></SPAN>-DF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y5</P><P>6I-0I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TT-4I&nbsp;&nbsp;&nbsp; 65-p9&nbsp;&nbsp;&nbsp; 34-FR&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 14pt;">58</SPAN>-Oi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58</P><P>7R-UP&nbsp;&nbsp; <SPAN style="font-size: 14pt;">6T</SPAN>-UU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6T</P><P></P><P>Key will come from last field and need to remove '-'</P><P></P><P>can some one pls help me how to create key.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Key-field/m-p/1133113#M910560 priyarane 2020-11-25T16:16:04Z Re: Key field https://community.qlik.com/t5/QlikView/Key-field/m-p/1133114#M910561 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>SubField(Alt(Child4, <SPAN style="font-size: 13.3333px;">Child3, <SPAN style="font-size: 13.3333px;">Child2, <SPAN style="font-size: 13.3333px;">Child1</SPAN></SPAN></SPAN>), '-', 1) as Key</STRONG></P></BODY></HTML> Thu, 16 Jun 2016 15:01:29 GMT https://community.qlik.com/t5/QlikView/Key-field/m-p/1133114#M910561 sunny_talwar 2016-06-16T15:01:29Z Re: Key field https://community.qlik.com/t5/QlikView/Key-field/m-p/1133115#M910562 <HTML><HEAD></HEAD><BODY><P>Or this if Child column won't be true nulls <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SubField(If(Len(Trim(Child4)) &gt; 0, Child4,</STRONG></P><P><STRONG style="color: #3d3d3d; font-size: 13.3333px; font-style: inherit; font-family: inherit; font-weight: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Len(Trim(Child3)) &gt; 0, Child3,</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-size: 13.3333px; font-style: inherit; font-family: inherit; font-weight: inherit;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Len(Trim(Child2)) &gt; 0, Child2, <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">Child1</SPAN></SPAN>))), '-', 1) as Key</STRONG></P></BODY></HTML> Thu, 16 Jun 2016 15:03:02 GMT https://community.qlik.com/t5/QlikView/Key-field/m-p/1133115#M910562 sunny_talwar 2016-06-16T15:03:02Z Re: Key field https://community.qlik.com/t5/QlikView/Key-field/m-p/1133116#M910563 <HTML><HEAD></HEAD><BODY><P>Here is another option:</P><P></P><P></P><P></P><P>LOAD * ,</P><P> <STRONG> Subfield(Subfield(Trim(Child1 &amp;' '&amp;Child2 &amp;' '&amp;Child3 &amp;' '&amp;Child4),' ',-1),'-',1) as Key2;</STRONG></P><P>LOAD * INLINE [</P><P>Parent,&nbsp;&nbsp; Child1,&nbsp;&nbsp; Child2 ,&nbsp; Child3 ,&nbsp; Child4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Key - We need to create like below</P><P>12-CX ,&nbsp; D1-39,&nbsp;&nbsp; 4R-8Y,&nbsp;&nbsp; Y5-DF,&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y5</P><P>6I-0I ,&nbsp;&nbsp;&nbsp;&nbsp; TT-4I ,&nbsp;&nbsp; 65-p9 ,&nbsp;&nbsp; 34-FR&nbsp; ,&nbsp;&nbsp; 58-Oi ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58</P><P>7R-UP ,&nbsp; 6T-UU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,,,,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6T</P><P>];</P></BODY></HTML> Thu, 16 Jun 2016 15:09:09 GMT https://community.qlik.com/t5/QlikView/Key-field/m-p/1133116#M910563 swuehl 2016-06-16T15:09:09Z Re: Key field https://community.qlik.com/t5/QlikView/Key-field/m-p/1133117#M910564 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P>Try this:</P><P>SubField(</P><P>&nbsp;&nbsp;&nbsp; SUBFIELD(Parent</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child1)&gt;0,'#'&amp;Child1)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child2)&gt;0,'#'&amp;Child2)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child3)&gt;0,'#'&amp;Child3)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child4)&gt;0,'#'&amp;Child4),'#',</P><P>&nbsp;&nbsp;&nbsp; SubStringCount(</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child1)&gt;0,'#'&amp;Child1)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child2)&gt;0,'#'&amp;Child2)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child3)&gt;0,'#'&amp;Child3)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;If(Len(Child4)&gt;0,'#'&amp;Child4),'#')+1),'-',1)</P><P></P><P>Regards!</P></BODY></HTML> Thu, 16 Jun 2016 15:09:59 GMT https://community.qlik.com/t5/QlikView/Key-field/m-p/1133117#M910564 Anonymous 2016-06-16T15:09:59Z