topic Re: Alternate state, aggr function for intersection of 2 dimensions in QlikView https://community.qlik.com/t5/QlikView/Alternate-state-aggr-function-for-intersection-of-2-dimensions/m-p/838717#M656761 <HTML><HEAD></HEAD><BODY><P>ok, this seems to be working,&nbsp; I need to test further:</P><P></P><P>=aggr(only({&lt;ASSET_CLASS=P({A}) * P({B})&gt;} ASSET_CLASS), ASSET_CLASS) </P></BODY></HTML> Fri, 22 May 2015 19:48:48 GMT gerrycastellino 2015-05-22T19:48:48Z Alternate state, aggr function for intersection of 2 dimensions https://community.qlik.com/t5/QlikView/Alternate-state-aggr-function-for-intersection-of-2-dimensions/m-p/838716#M656760 <HTML><HEAD></HEAD><BODY><P>I have a dimension asset_class,&nbsp; that I want to change based on the intersection of 2 other dimensions that are in alternate state(s)</P><P>A, B.</P><P></P><P>How do I structure my asset_class expression to list this intersection ?</P><P>I'm trying something like the below, but need help ....</P><P></P><P>=aggr(only({A*B} ASSET_CLASS), ASSET_CLASS) </P><P></P><P>Is the aggr function to only way to achieve this ?</P><P></P><P>Gerry.</P></BODY></HTML> Fri, 22 May 2015 19:12:05 GMT https://community.qlik.com/t5/QlikView/Alternate-state-aggr-function-for-intersection-of-2-dimensions/m-p/838716#M656760 gerrycastellino 2015-05-22T19:12:05Z Re: Alternate state, aggr function for intersection of 2 dimensions https://community.qlik.com/t5/QlikView/Alternate-state-aggr-function-for-intersection-of-2-dimensions/m-p/838717#M656761 <HTML><HEAD></HEAD><BODY><P>ok, this seems to be working,&nbsp; I need to test further:</P><P></P><P>=aggr(only({&lt;ASSET_CLASS=P({A}) * P({B})&gt;} ASSET_CLASS), ASSET_CLASS) </P></BODY></HTML> Fri, 22 May 2015 19:48:48 GMT https://community.qlik.com/t5/QlikView/Alternate-state-aggr-function-for-intersection-of-2-dimensions/m-p/838717#M656761 gerrycastellino 2015-05-22T19:48:48Z