Cyclic Group is displaying Express in Chart Header. How to resolve it?

[#1]

Hi Guys,

I have created a Cyclic Group named as [Date Hierarchy]

Year-->Quarter-->Month-->Week-->Date

For Year I have used field [CREATED YEAR] but for Quarter I have used expression =[CREATED YEAR] &'-'&[CREATED QUARTER]

and given a Label CREATED QUARTER to this expression. Same way for Month

When I used [Date Hierarchy] in my Chart header like this ='Count by '& GetCurrentField([Date Hierarchy]) I am not getting expected result when I select Quarter from Cyclic Group. It is displaying Count by =[CREATED YEAR] &'-'&[CREATED QUARTER]

How can I resolve it?

Do not want to write complex If statement in Chart header.

[amit_saini]

Please share your app.

Thanks,
AS

[Anonymous]

Try to recreate the Group..may solve the issue..some times I expreeinced qlikview behaved stangely in this kind of situations..

[#4]

Guys,

In my case, It is never displaying Label name of calculated expression.

I handled those expression in script side and now when i try to run it is display exact field name not the label name.

Anyone who has done with label could you please share the application.

[jagan]

Hi,

If you share the sample app and your expected result it would be easier to resolve this.

Regards,

Jagan.

[jonathandienst · Accepted solution]

GetCurrentField() displays the selected field or expression of the group. It does NOT display the label. Period.

If you want the label names to appear in your app, you will need to write an expression for the label that matches the field name or expression and displays the label text, something like this:

     =Pick(Match(GetCurrentField(groupname), 'expression1', 'expression2', 'expression3'), 'label 1', 'label 2', 'label3')

You could also use wildmatch() with fragments of the full expressions if they are too long, or contain quotes.

HTH

Jonathan

[#7]

Hi Jonathan,

Thanks for clarifying it. You are right It is no way taking the label name of fields under group. It is always taking original field name or expression if any.

I have not tried this =Pick(Match(GetCurrentField(groupname), 'expression1', 'expression2', 'expression3'), 'label 1', 'label 2', 'label3')

Will try and post it how it goes