Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Searching for a function that returns the number of the "drill-down" level

hi all,

I just created a drill down group called "Test1"

This group is structured like

Area => shop => user => voucher.

is there a function, that returns when the "area" is "active"  number 1, when "shop"  is activ number2 and so on......

thanks in advance

daniel

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Hi Daniel,

check out this function:

getcurrentfield ( GroupName

Returns the name of the currently active field in a group.

Example

getcurrentfield( myGroup )

if you combine it with match function like match(getcurrentfield( Test1 ), 'Area','shop','user','voucher')

it should do what you want.

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Hi Daniel,

check out this function:

getcurrentfield ( GroupName

Returns the name of the currently active field in a group.

Example

getcurrentfield( myGroup )

if you combine it with match function like match(getcurrentfield( Test1 ), 'Area','shop','user','voucher')

it should do what you want.

Hope this helps,

Stefan

Not applicable
Author

hi stefan,

thank you thats definitly what i am looking for.

so long

daniel

PS: i just wonder why the my group name is underlined in red color... but the function works right either way.