Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

micheledenardi
Valued Contributor

Get Drill Down level from formula

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

Tags (1)
1 Solution

Accepted Solutions

Re: Get Drill Down level from formula

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

2 Replies

Re: Get Drill Down level from formula

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

Re: Get Drill Down level from formula

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)


talk is cheap, supply exceeds demand
Community Browser