Get Drill Down level from formula

[micheledenardi]

Hi,

i'm new in qlik and i don't know how to get current drill down level from formula.

i explain my problem....

i have one dimension composed by 3 drill down level.

in the first level i want to see the value on the graph column only for value greater than 10000

in the second level i want to see the value in on the graph column only for value greater than 5000

in the third level i want to see the value in on the graph column only for value greater than 1000

there is a funcion to do this ?

thank's

[alexandros17 · Accepted solution]

Yes,

use getcurrentfield(myGroup)

where myGroup is the name of the drill down Group

In this way you can test:

If(getcurrentfield(myGroup)='myFirstDimension', ...., ....)

let me know

[Gysbert_Wassenaar]

Create three expressions, one for each drill down level. Use the Conditional option of the expressions to show/hide the expressions depending on the active field in the drill down group: =if(getcurrentfield(MyDrillDownGroup='First level', 1, 0)