https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698998#M725065 <P>Thank You so much its working so great...</P> Tue, 05 May 2020 08:12:02 GMT bsbernabe 2020-05-05T08:12:02Z https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698968#M725063 <P>Hello There,</P><P>How to get value in another field?</P><P>I try this : if(([Sub_Value]), 'Migrated', [Sub file])&nbsp;</P><P>&nbsp;</P><TABLE width="694"><TBODY><TR><TD width="145">Sub_Value</TD><TD width="192">Sub_file</TD><TD width="198">output</TD><TD width="159">Should be</TD></TR><TR><TD>General office clerks</TD><TD>NONE</TD><TD>NONE</TD><TD>General office clerks</TD></TR><TR><TD>Migrated</TD><TD>SARI SARI STORE</TD><TD>SARI SARI STORE</TD><TD>SARI SARI STORE</TD></TR><TR><TD>Migrated</TD><TD>FARM CORN FIELD</TD><TD>FARM CORN FIELD</TD><TD>FARM CORN FIELD</TD></TR><TR><TD>Migrated</TD><TD>FARMING</TD><TD>FARMING</TD><TD>FARMING</TD></TR><TR><TD>Migrated</TD><TD>FISH VENDOR</TD><TD>FISH VENDOR</TD><TD>FISH VENDOR</TD></TR><TR><TD>Migrated</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD></TR><TR><TD>Migrated</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD></TR><TR><TD>Migrated</TD><TD>FARMING</TD><TD>FARMING</TD><TD>FARMING</TD></TR><TR><TD>Migrated</TD><TD>MAGSAYO STORE</TD><TD>MAGSAYO STORE</TD><TD>MAGSAYO STORE</TD></TR><TR><TD>Car, taxi and van drivers</TD><TD>-</TD><TD>-</TD><TD>Car, taxi and van drivers</TD></TR><TR><TD>Other field crop farmers</TD><TD>-</TD><TD>-</TD><TD>Other field crop farmers</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Best Regards,</P><P>Bing</P> Sat, 16 Nov 2024 00:44:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698968#M725063 bsbernabe 2024-11-16T00:44:18Z https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698986#M725064 <TABLE width="694"><TBODY><TR><TD width="145"><STRONG>Sub_Value</STRONG></TD><TD width="192"><STRONG>Sub_file</STRONG></TD><TD width="198"><STRONG>output</STRONG></TD><TD width="159"><STRONG>Should be</STRONG></TD></TR><TR><TD>General office clerks</TD><TD>NONE</TD><TD>NONE</TD><TD>General office clerks</TD></TR><TR><TD>Migrated</TD><TD>SARI SARI STORE</TD><TD>SARI SARI STORE</TD><TD>SARI SARI STORE</TD></TR><TR><TD>Migrated</TD><TD>FARM CORN FIELD</TD><TD>FARM CORN FIELD</TD><TD>FARM CORN FIELD</TD></TR><TR><TD>Migrated</TD><TD>FARMING</TD><TD>FARMING</TD><TD>FARMING</TD></TR><TR><TD>Migrated</TD><TD>FISH VENDOR</TD><TD>FISH VENDOR</TD><TD>FISH VENDOR</TD></TR><TR><TD>Migrated</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD></TR><TR><TD>Migrated</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD><TD>RUBBER PLANTATION</TD></TR><TR><TD>Migrated</TD><TD>FARMING</TD><TD>FARMING</TD><TD>FARMING</TD></TR><TR><TD>Migrated</TD><TD>MAGSAYO STORE</TD><TD>MAGSAYO STORE</TD><TD>MAGSAYO STORE</TD></TR><TR><TD>Car, taxi and van drivers</TD><TD>-</TD><TD>-</TD><TD>Car, taxi and van drivers</TD></TR><TR><TD>Other field crop farmers</TD><TD>-</TD><TD>-</TD><TD>Other field crop farmers</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><SPAN>Try this expression: </SPAN></P><P><FONT face="courier new,courier"><SPAN>if([Sub_Value]='Migrated',<BR /></SPAN></FONT><FONT face="courier new,courier"><SPAN>&nbsp; &nbsp;[Sub_file],<BR />&nbsp; &nbsp;[Sub_Value]<BR />&nbsp; &nbsp;)&nbsp; as output</SPAN></FONT></P> Tue, 05 May 2020 07:50:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698986#M725064 Vegar 2020-05-05T07:50:02Z https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698998#M725065 <P>Thank You so much its working so great...</P> Tue, 05 May 2020 08:12:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-value-in-another-field/m-p/1698998#M725065 bsbernabe 2020-05-05T08:12:02Z