Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-04-23 10:41 AM

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,

324 Views
0 Likes
0 Replies