Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using a dimension name as a reference in another dimension

Hello,

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.

=aggr(sum([Member Count]),[Members Channel] )

[Member Channel] is one of the dimensions in the hierarchic dimension.

Now this second dimension needs to change with the first dimension.

I tried using the GetCurrentField, but its not working.

This is what i tried and didnt work.

=aggr(sum([Member Count]),GetCurrentField(Channel) )

So is it possible to call a dimension from another dimension?

Thanks again,

Regards,

Community Browser