topic Re: Dynamic Target Line Expression in QlikView

Dynamic Target Line Expression

Fri, 21 Nov 2014 16:33:15 GMT

I got a requirement to include target line for chart which has a drilldown from Year-->Month-->Week-->day-->Hour.

Right now I was given a static value for day, Can I make an expression out of it and make it dynamic upon drill down selection.

Any Ideas would be really appreciated..

Thanks!!

JonnyPoole — Fri, 21 Nov 2014 16:45:02 GMT

You can, if your Drill group is called 'DrillGroup', you can use GetCurrentField() function to return the level:

EX:

if( GetCurrentField([DrillGroup]) = 'Day' , 1000)

veidlburkhard — Fri, 21 Nov 2014 16:46:48 GMT

Hi Sanhya,

you can use: GetCurrentField(YourDrillDownGroup)

which gives you the fieldname you are currently displaying from your drilldown group.

Don't you mind Qlikview will mark this as a mistake but will execute it correctly.

Hope this helps

Burkhard

Fri, 21 Nov 2014 17:15:23 GMT

I don't see my Drilldown Group name to write in expression.

JonnyPoole — Fri, 21 Nov 2014 17:24:27 GMT

Here is a screenshot to guide you.

In getcurrentfield() wrap the drill group name in square brackets []

as mentioned above:

EX:

if( GetCurrentField([DrillGroup]) = 'Day' , 1000)

Fri, 21 Nov 2014 17:36:38 GMT

anything wrong here?

JonnyPoole — Fri, 21 Nov 2014 17:38:47 GMT

yes ! you have at typo ! your group is actually: Scheudling DrillDown.

However, even after the correction it may still underling a mistake (but say OK) above. if that is the case just hit ok

Fri, 21 Nov 2014 18:42:22 GMT

Thank you.. it worked well..