topic Re: How to split value to two values in QlikView https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498203#M1137592 <HTML><HEAD></HEAD><BODY><P>Thanks and it's showing same values as PhoneNoMobile in PhoneNoWork but I have to get the second Phone No in PhoneNoWork if PhoneNoWork contains NULL Values only.</P></BODY></HTML> Mon, 21 Oct 2013 14:40:05 GMT 2013-10-21T14:40:05Z How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498201#M1137590 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have PhoneNoMobile and PhoneNoWork columns in sql table with values 447341891543,447897674285 as combined in PhoneNoMobile&nbsp; and column PhoneNoWork contains some NULL values and values with Data .</P><P></P><P>I have to split the above value as PhoneNoMobile=7341891543 and PhoneNoWork=447897674285</P><P></P><P>Is it possible to get this and I have to split this values only when PhoneNoWork contains NULL values i,e if PhoneNoWork=NULL then it should replace with 44789674285. Please help</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 21 Oct 2013 14:25:54 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498201#M1137590 2013-10-21T14:25:54Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498202#M1137591 <HTML><HEAD></HEAD><BODY><P>You create an expression:</P><P></P><P>If(IsNull(PhoneNoMobile),If(IsNull(PhoneNoWork),'No phone number',PhoneNoWork),PhoneNoMobile)</P></BODY></HTML> Mon, 21 Oct 2013 14:33:24 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498202#M1137591 javier_florian 2013-10-21T14:33:24Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498203#M1137592 <HTML><HEAD></HEAD><BODY><P>Thanks and it's showing same values as PhoneNoMobile in PhoneNoWork but I have to get the second Phone No in PhoneNoWork if PhoneNoWork contains NULL Values only.</P></BODY></HTML> Mon, 21 Oct 2013 14:40:05 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498203#M1137592 2013-10-21T14:40:05Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498204#M1137593 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this on your load statement</P><P></P><P>Alt(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">PhoneNoWork</SPAN>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">PhoneNoMobil</SPAN>) as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">PhoneNoWork</SPAN></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards,</SPAN></P><P>Aurélien</P></BODY></HTML> Mon, 21 Oct 2013 14:41:07 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498204#M1137593 Aurelien_Martinez 2013-10-21T14:41:07Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498205#M1137594 <HTML><HEAD></HEAD><BODY><P>For such a splitting you could use subfield like subfield(FIELD, ',', 1) as FIELD1.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 21 Oct 2013 14:42:15 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498205#M1137594 marcus_sommer 2013-10-21T14:42:15Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498206#M1137595 <HTML><HEAD></HEAD><BODY><P>Thanks and still it's showing as earlier any help please.</P></BODY></HTML> Mon, 21 Oct 2013 14:43:14 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498206#M1137595 2013-10-21T14:43:14Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498207#M1137596 <HTML><HEAD></HEAD><BODY><P>Can you include a value like an example? Function with IsNull or Alt must works...</P></BODY></HTML> Mon, 21 Oct 2013 14:50:31 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498207#M1137596 javier_florian 2013-10-21T14:50:31Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498208#M1137597 <HTML><HEAD></HEAD><BODY><P>Thanks and if PhoneNoWork contains NULL values will below expression work?</P><P></P><P>If(PhoneNoWork='NULL',Subfield(PhoneNoMobile,',',2),PhoneNoWork)</P></BODY></HTML> Mon, 21 Oct 2013 15:00:44 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498208#M1137597 2013-10-21T15:00:44Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498209#M1137598 <HTML><HEAD></HEAD><BODY><P>Yes,</P><P></P><P>but I think</P><P></P><P>Alt(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">PhoneNoWork</SPAN>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Subfield(PhoneNoMobile,',',2)</SPAN>)</P><P></P><P>is better <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 21 Oct 2013 15:04:08 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498209#M1137598 Aurelien_Martinez 2013-10-21T15:04:08Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498210#M1137599 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>If(isnull(PhoneNoWork),Subfield(PhoneNoMobile,',',2),PhoneNoWork)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 21 Oct 2013 15:04:41 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498210#M1137599 marcus_sommer 2013-10-21T15:04:41Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498211#M1137600 <HTML><HEAD></HEAD><BODY><P>Thanks and it's working.</P></BODY></HTML> Mon, 21 Oct 2013 15:09:53 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498211#M1137600 2013-10-21T15:09:53Z Re: How to split value to two values https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498212#M1137601 <HTML><HEAD></HEAD><BODY><P>Thanks and it's working.</P></BODY></HTML> Mon, 21 Oct 2013 15:11:23 GMT https://community.qlik.com/t5/QlikView/How-to-split-value-to-two-values/m-p/498212#M1137601 2013-10-21T15:11:23Z