Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP
MVP

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

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

2 Replies
MVP
MVP

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

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

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

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.