topic Hi there i am new please help in App Development https://community.qlik.com/t5/App-Development/Hi-there-i-am-new-please-help/m-p/92262#M6136 <HTML><HEAD></HEAD><BODY><P>HI all </P><P>Can any one tell me how to write this sql command in Code area of a field here</P><P></P><P></P><P>Select * from RVW_Modified_Sheet where Type = 'Assets'</P><P></P><P>OR </P><P></P><P>Select * <SPAN style="font-size: 13.3333px;">RVW_Modified_Sheet where account_code like '10%'</SPAN></P></BODY></HTML> Thu, 20 Sep 2018 11:56:40 GMT Anonymous 2018-09-20T11:56:40Z Hi there i am new please help https://community.qlik.com/t5/App-Development/Hi-there-i-am-new-please-help/m-p/92262#M6136 <HTML><HEAD></HEAD><BODY><P>HI all </P><P>Can any one tell me how to write this sql command in Code area of a field here</P><P></P><P></P><P>Select * from RVW_Modified_Sheet where Type = 'Assets'</P><P></P><P>OR </P><P></P><P>Select * <SPAN style="font-size: 13.3333px;">RVW_Modified_Sheet where account_code like '10%'</SPAN></P></BODY></HTML> Thu, 20 Sep 2018 11:56:40 GMT https://community.qlik.com/t5/App-Development/Hi-there-i-am-new-please-help/m-p/92262#M6136 Anonymous 2018-09-20T11:56:40Z Re: Hi there i am new please help https://community.qlik.com/t5/App-Development/Hi-there-i-am-new-please-help/m-p/92263#M6137 <HTML><HEAD></HEAD><BODY><P>btw i tried an if statement and it didn't work </P><P></P><P>=if(Type = 'Assets' , SUM(Balance) , 0 )</P></BODY></HTML> Thu, 20 Sep 2018 12:03:24 GMT https://community.qlik.com/t5/App-Development/Hi-there-i-am-new-please-help/m-p/92263#M6137 Anonymous 2018-09-20T12:03:24Z