topic Re: Label syntax for drill group required in QlikView

Label syntax for drill group required

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Label syntax for drill group required

micheledenardi — Tue, 07 Nov 2017 07:33:41 GMT

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',........))

Re: Label syntax for drill group required

Anonymous — Tue, 07 Nov 2017 09:20:07 GMT

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)

Re: Label syntax for drill group required

micheledenardi — Tue, 07 Nov 2017 09:52:21 GMT

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.

Re: Label syntax for drill group required

Anonymous — Tue, 07 Nov 2017 13:22:29 GMT

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

Re: Label syntax for drill group required

micheledenardi — Tue, 07 Nov 2017 14:43:27 GMT

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