Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.