topic Re: Set Analysis Help in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130032#M9147 <HTML><HEAD></HEAD><BODY><P>Make sure all fields being used in the expression do exist in the data model.</P><P>Can you provide a sample app?</P></BODY></HTML> Sat, 15 Sep 2018 08:28:52 GMT vunguyenq89 2018-09-15T08:28:52Z Set Analysis Help https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130031#M9146 <HTML><HEAD></HEAD><BODY><P>HI Friends ,</P><P></P><P>I am writing a calculated dimension</P><P></P><P></P><P>=only({&lt;[%KPI_KEY]={'ARIEL'},Metric=}&gt;}if((DATE &lt;= END_DT and DATE &gt;= EndMonth13 ),MonthYear))</P><P></P><P></P><P>it doesn't throw error instead says invalid dimension.&nbsp; Can anyone help ?</P></BODY></HTML> Fri, 14 Sep 2018 21:44:09 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130031#M9146 arusanah 2018-09-14T21:44:09Z Re: Set Analysis Help https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130032#M9147 <HTML><HEAD></HEAD><BODY><P>Make sure all fields being used in the expression do exist in the data model.</P><P>Can you provide a sample app?</P></BODY></HTML> Sat, 15 Sep 2018 08:28:52 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130032#M9147 vunguyenq89 2018-09-15T08:28:52Z Re: Set Analysis Help https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130033#M9148 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Try this:</SPAN></P><P>Aggr(only({&lt;[%KPI_KEY]={'ARIEL'},Metric=&gt;}if((DATE &lt;= END_DT and DATE &gt;= EndMonth13 ),MonthYear)),MonthYear)</P></BODY></HTML> Sat, 15 Sep 2018 10:25:08 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Help/m-p/130033#M9148 Quy_Nguyen 2018-09-15T10:25:08Z