topic Expression issue in QlikView

topic Expression issue in QlikView https://community.qlik.com/t5/QlikView/Expression-issue/m-p/522909#M1129947 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P><STRONG>Table:</STRONG></P><P>ID</P><P>000123</P><P>001234</P><P>000009876</P><P></P><P><STRONG>Table2:</STRONG></P><P><STRONG>ID</STRONG></P><P>123</P><P>1234</P><P>9876</P><P></P><P>i have 2 tables ID is the common field, but i don't want 0's of the <STRONG>Table. </STRONG></P><P></P><P></P><P>Thanks in Advance..............          </P></BODY></HTML> Tue, 03 Dec 2013 17:38:43 GMT paulwalker 2013-12-03T17:38:43Z Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/522909#M1129947 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P><STRONG>Table:</STRONG></P><P>ID</P><P>000123</P><P>001234</P><P>000009876</P><P></P><P><STRONG>Table2:</STRONG></P><P><STRONG>ID</STRONG></P><P>123</P><P>1234</P><P>9876</P><P></P><P>i have 2 tables ID is the common field, but i don't want 0's of the <STRONG>Table. </STRONG></P><P></P><P></P><P>Thanks in Advance..............          </P></BODY></HTML> Tue, 03 Dec 2013 17:38:43 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/522909#M1129947 paulwalker 2013-12-03T17:38:43Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/522910#M1129948 <HTML><HEAD></HEAD><BODY><P>Format ID from the first table to a number before loading it using num().</P></BODY></HTML> Tue, 03 Dec 2013 17:42:47 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/522910#M1129948 simondachstr 2013-12-03T17:42:47Z