topic Using a dimension name as a reference in another dimension in QlikView https://community.qlik.com/t5/QlikView/Using-a-dimension-name-as-a-reference-in-another-dimension/m-p/363783#M493938 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table with a 2 dimensions. The first one is a hierarchic dimension (called Channel) and the second one uses an aggr and a Total function on one of the fields.</P><P></P><P>=aggr(sum([Member Count]),[Members Channel] )</P><P></P><P>[Member Channel] is one of the dimensions in the hierarchic dimension.</P><P></P><P> Now this second dimension needs to change with the first dimension.</P><P></P><P>I tried using the GetCurrentField, but its not working. </P><P></P><P>This is what i tried and didnt work.</P><P></P><P>=aggr(sum([Member Count]),GetCurrentField(Channel) )</P><P></P><P>So is it possible to call a dimension from another dimension?</P><P></P><P>Thanks again,</P><P>Regards,</P></BODY></HTML> Mon, 23 Apr 2012 14:41:11 GMT 2012-04-23T14:41:11Z Using a dimension name as a reference in another dimension https://community.qlik.com/t5/QlikView/Using-a-dimension-name-as-a-reference-in-another-dimension/m-p/363783#M493938 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table with a 2 dimensions. The first one is a hierarchic dimension (called Channel) and the second one uses an aggr and a Total function on one of the fields.</P><P></P><P>=aggr(sum([Member Count]),[Members Channel] )</P><P></P><P>[Member Channel] is one of the dimensions in the hierarchic dimension.</P><P></P><P> Now this second dimension needs to change with the first dimension.</P><P></P><P>I tried using the GetCurrentField, but its not working. </P><P></P><P>This is what i tried and didnt work.</P><P></P><P>=aggr(sum([Member Count]),GetCurrentField(Channel) )</P><P></P><P>So is it possible to call a dimension from another dimension?</P><P></P><P>Thanks again,</P><P>Regards,</P></BODY></HTML> Mon, 23 Apr 2012 14:41:11 GMT https://community.qlik.com/t5/QlikView/Using-a-dimension-name-as-a-reference-in-another-dimension/m-p/363783#M493938 2012-04-23T14:41:11Z