topic Re: Cyclic Group is displaying Express in Chart Header. How to resolve it? in QlikView

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

Mon, 20 Apr 2015 03:54:19 GMT

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.

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

Anonymous — Mon, 20 Apr 2015 04:01:37 GMT

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

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

Anonymous — Mon, 20 Apr 2015 04:03:02 GMT

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

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

Mon, 20 Apr 2015 04:10:07 GMT

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

See the attached Screenshot

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

jagan — Mon, 20 Apr 2015 04:17:49 GMT

Hi,

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

Hope this helps you.

Regards,

Jagan.

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

Anonymous — Mon, 20 Apr 2015 04:28:25 GMT

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

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

amit_saini — Mon, 20 Apr 2015 04:28:59 GMT

Hi,

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

Thanks,

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

Mon, 20 Apr 2015 04:50:14 GMT

Hi All,

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

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

amit_saini — Mon, 20 Apr 2015 04:54:42 GMT

Hi ,

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

Thanks,
AS

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

Mon, 20 Apr 2015 05:09:50 GMT

I tried this too but not working.

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

amit_saini — Mon, 20 Apr 2015 05:18:23 GMT

Please share your app.

Thanks,
AS

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

Anonymous — Mon, 20 Apr 2015 05:38:35 GMT

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

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

Mon, 20 Apr 2015 08:21:56 GMT

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.

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

jagan — Tue, 21 Apr 2015 02:52:34 GMT

Hi,

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

Regards,

Jagan.

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

jonathandienst — Tue, 21 Apr 2015 05:34:37 GMT

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

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

Wed, 22 Apr 2015 11:16:56 GMT

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