topic Re: field values in QlikView https://community.qlik.com/t5/QlikView/field-values/m-p/1343447#M838915 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>LOAD datasource, <STRONG>If(SubStringCount(datasource,'airtel'),'airtel', If(SubStringCount(datasource,'voda'),'voda', If(SubStringCount(datasource,'bsnl'),'bsnl'))) as datasource1</STRONG> Inline [</P><P>datasource</P><P>airtel</P><P>airtel 3mbps</P><P>airtel 5mbps</P><P>vodafone 3mbps</P><P>voda</P><P>vodafone</P><P>aircel 5mbps</P><P>aircel</P><P>aircel 3mbps</P><P>bsnl 2mbps</P><P>bsnl</P><P>];</P></BODY></HTML> Mon, 15 May 2017 07:31:01 GMT Anil_Babu_Samineni 2017-05-15T07:31:01Z field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343440#M838901 <HTML><HEAD></HEAD><BODY><P>Hi all ,</P><P></P><P>I have a field&nbsp; datasource and values in it is </P><P>airtel</P><P>airtel 3mbps</P><P>airtel 5mbps</P><P>vodafone 3mbps</P><P>voda</P><P>vodafone</P><P></P><P>now i want to show </P><P>airtel</P><P style="font-size: 13.3333px;">airtel 3mbps</P><P style="font-size: 13.3333px;">airtel 5mbps&nbsp; all should be as one unique name airtel so as vodafone</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">can anyone help me</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343440#M838901 nareshthavidishetty 2020-11-25T16:16:04Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343441#M838903 <HTML><HEAD></HEAD><BODY><P>Finally, How you want to see in output?</P></BODY></HTML> Mon, 15 May 2017 07:08:05 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343441#M838903 Anil_Babu_Samineni 2017-05-15T07:08:05Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343442#M838905 <HTML><HEAD></HEAD><BODY><P>airtel</P><P>vodafone</P><P>bsnl</P><P>aircel</P><P></P><P></P><P>like this i want my output</P></BODY></HTML> Mon, 15 May 2017 07:12:20 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343442#M838905 nareshthavidishetty 2017-05-15T07:12:20Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343443#M838907 <HTML><HEAD></HEAD><BODY><P>Please share example output...</P></BODY></HTML> Mon, 15 May 2017 07:12:31 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343443#M838907 prma7799 2017-05-15T07:12:31Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343444#M838909 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a field&nbsp; datasource and values in it is</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">datasource:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">airtel</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">airtel 3mbps</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">airtel 5mbps</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">vodafone 3mbps</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">voda</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">vodafone</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aircel 5mbps</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aircel</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aircel 3mbps</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">bsnl 2mbps</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">bsnl</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">output should be</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">datasource:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">airtel</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">vodafone</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aircel</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">bsnl</P></BODY></HTML> Mon, 15 May 2017 07:25:10 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343444#M838909 nareshthavidishetty 2017-05-15T07:25:10Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343445#M838911 <HTML><HEAD></HEAD><BODY><P>am not sure but try this.</P><P></P><P>Network:</P><P>load * Inline [</P><P>Data</P><P>airtel</P><P></P><P>airtel 3mbps</P><P></P><P>airtel 5mbps</P><P></P><P>vodafone 3mbps</P><P></P><P>voda</P><P></P><P>vodafone</P><P></P><P> ];</P><P></P><P> LOAD *</P><P></P><P> , subfield( Data,' ',1) as firstWord</P><P></P><P> Resident Network;</P><P></P><P><IMG alt="dta.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163324_dta.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 15 May 2017 07:25:56 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343445#M838911 Chanty4u 2017-05-15T07:25:56Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343446#M838913 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Do like this</P><P></P><P>sunfield(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">datasource,' ',1) as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">datasource</SPAN></SPAN></P></BODY></HTML> Mon, 15 May 2017 07:29:40 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343446#M838913 qlikview979 2017-05-15T07:29:40Z Re: field values https://community.qlik.com/t5/QlikView/field-values/m-p/1343447#M838915 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>LOAD datasource, <STRONG>If(SubStringCount(datasource,'airtel'),'airtel', If(SubStringCount(datasource,'voda'),'voda', If(SubStringCount(datasource,'bsnl'),'bsnl'))) as datasource1</STRONG> Inline [</P><P>datasource</P><P>airtel</P><P>airtel 3mbps</P><P>airtel 5mbps</P><P>vodafone 3mbps</P><P>voda</P><P>vodafone</P><P>aircel 5mbps</P><P>aircel</P><P>aircel 3mbps</P><P>bsnl 2mbps</P><P>bsnl</P><P>];</P></BODY></HTML> Mon, 15 May 2017 07:31:01 GMT https://community.qlik.com/t5/QlikView/field-values/m-p/1343447#M838915 Anil_Babu_Samineni 2017-05-15T07:31:01Z