Label syntax for drill group required

[Anonymous]

How to represent this in code :

Only(All Higher fields) & '>' & 'curreny field name's

Please text me the qlikview syntax that I can apply on the label so that it shows

E.g. SalesRepA> Product

[micheledenardi]

Use GetCurrentField function()

Only(All Higher fields) & '>' & GetCurrentField(YourDrillGroupName)

or if you want to use a custom title (different from DrillDown field name):

Only(All Higher fields) & '>' & if(GetCurrentField(YourDrillGroupName)='Product','Custom Product Title',if(GetCurrentField(YourDrillGroupName)='Material','Custom Material Title',........))

[Anonymous]

Can you please Text me the exact QlikView syntax.

I have a chart with drill down Time dimension - Year , quarter, month . Expression is sum of population.

I want to represent the label of dimension and title of the chart in the best possible manner.

The above only () .... Is not working.

So can you please text me the exact QlikView syntax .

Getcurrentfield(group name) is working.

Can you text me the exact QlikView syntax including the Getcurrentfield (group name) for best representation of both title and label. (You can refer previous post but need exact  syntax)

[micheledenardi]

Which is the expected result ?

Could be something like this:

=if(GetCurrentField(YourDrillGroupName)='Time','Time',if(GetCurrentField(YourDrillGroupName)='Year','Time>Year',if(GetCurrentField(YourDrillGroupName)='Quarter','Time>Year>Quarter',if(GetCurrentField(YourDrillGroupName)='Month','Time>Year>Quarter>Month'))))

Words in bold must match with your drill down dimensions name.

[Anonymous]

Hi Micheal, this is the expected result. Can you please share the exact syntax with me for the label expression.

Requirement : When Creating a Drill group, add an expression for the label of the field in the drill group.  The expression should be equal to Only(All Higher fields) & ‘>’ & ‘current field name’, so that it equates to SalesRepA>Product.  SalesRepA is the item which was drilled into, Product is the values which are represented in the chart

Please share the exact syntax

[micheledenardi]

Probably:

if(GetCurrentField(YourDrillGroupName)='SalesRepA','SalesRepA',

     if(GetCurrentField(YourDrillGroupName)='Product','SalesRepA>Product'))

but it's difficult to give you the exact syntax without have the .qvw file