topic How to use only in dimension side in QlikView https://community.qlik.com/t5/QlikView/How-to-use-only-in-dimension-side/m-p/57074#M9500 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to use only() function in dimension side.</P><P></P><P>For EX: If I will select B option and field A is having only 1 value related to B then it should display A/B like that.</P></BODY></HTML> Tue, 06 Mar 2018 12:01:05 GMT Anonymous 2018-03-06T12:01:05Z How to use only in dimension side https://community.qlik.com/t5/QlikView/How-to-use-only-in-dimension-side/m-p/57074#M9500 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to use only() function in dimension side.</P><P></P><P>For EX: If I will select B option and field A is having only 1 value related to B then it should display A/B like that.</P></BODY></HTML> Tue, 06 Mar 2018 12:01:05 GMT https://community.qlik.com/t5/QlikView/How-to-use-only-in-dimension-side/m-p/57074#M9500 Anonymous 2018-03-06T12:01:05Z Re: How to use only in dimension side https://community.qlik.com/t5/QlikView/How-to-use-only-in-dimension-side/m-p/57075#M9501 <HTML><HEAD></HEAD><BODY><P>try in dim:</P><P></P><P>=aggr(only(Dim1),Dim1,Dim2)</P></BODY></HTML> Tue, 06 Mar 2018 12:02:36 GMT https://community.qlik.com/t5/QlikView/How-to-use-only-in-dimension-side/m-p/57075#M9501 Chanty4u 2018-03-06T12:02:36Z