topic Re: How to select data with other DB table in App Development https://community.qlik.com/t5/App-Development/How-to-select-data-with-other-DB-table/m-p/1271736#M26159 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>'$=&lt;ID={1}&gt;ResMon'</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>What do you expect that to do? What's it supposed to mean? The syntax looks so bizarre to me that I have no idea what you're trying to do there.</P></BODY></HTML> Mon, 05 Dec 2016 12:05:28 GMT Gysbert_Wassenaar 2016-12-05T12:05:28Z How to select data with other DB table https://community.qlik.com/t5/App-Development/How-to-select-data-with-other-DB-table/m-p/1271735#M26158 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i need to select months with field from other DB.</P><P></P><P>With expression </P><P></P><P style="padding-left: 60px;">count(distinct </P><P style="padding-left: 60px;">{$&lt;</P><P style="padding-left: 60px;">Year={2016} ,[Date-Sales_Date.autoCalendar.Month]={'$=&lt;ID={1}&gt;ResMon'}, [Target]={"Ppl"}</P><P style="padding-left: 60px;">&gt;}</P><P style="padding-left: 60px;">[Client])</P><P></P><P>where &lt;ID={1}&gt;ResMon is other DB criteria.</P><P></P><P>Qlik Sense return ad hoc element error.</P><P></P><P>How to solve problem?</P></BODY></HTML> Fri, 02 Dec 2016 12:50:38 GMT https://community.qlik.com/t5/App-Development/How-to-select-data-with-other-DB-table/m-p/1271735#M26158 2016-12-02T12:50:38Z Re: How to select data with other DB table https://community.qlik.com/t5/App-Development/How-to-select-data-with-other-DB-table/m-p/1271736#M26159 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>'$=&lt;ID={1}&gt;ResMon'</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>What do you expect that to do? What's it supposed to mean? The syntax looks so bizarre to me that I have no idea what you're trying to do there.</P></BODY></HTML> Mon, 05 Dec 2016 12:05:28 GMT https://community.qlik.com/t5/App-Development/How-to-select-data-with-other-DB-table/m-p/1271736#M26159 Gysbert_Wassenaar 2016-12-05T12:05:28Z