Solved: Cyclic Group is displaying Express in Chart Header... - Qlik Community

Report Inappropriate Content · ‎2015-04-19

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.

jonathandienst · ‎2015-04-21

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Anonymous · ‎2015-04-20

pls share sample app..would be easy to understand and resolve..

Anonymous · ‎2015-04-20

I suspect you might have not given label correctly. I think you have given the Created Quarter label to other field. Pls check once

Report Inappropriate Content · ‎2015-04-20

Actually, It is not picking the Label, It is picking the Fields name used for creating group.

See the attached Screenshot

jagan · ‎2015-04-20

Hi,

You used the calculated expressions, so give the caption in the Label text box for corresponding dimensions.

Hope this helps you.

Regards,

Jagan.

Anonymous · ‎2015-04-20

select each calculation in Cyclic group and add a label under ..as shown below image.

amit_saini · ‎2015-04-20

Hi,

Please see below , you need to write label name against your expression or field :

Thanks,

AS

Report Inappropriate Content · ‎2015-04-20

Hi All,

I have already given label Name to each calculated expression and It is not working. Please see screenshot.

amit_saini · ‎2015-04-20

Hi ,

Looks to me this is caption issue, uncheck "Show Caption" and see if it works.

Thanks,
AS

Report Inappropriate Content · ‎2015-04-20

I tried this too but not working.

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