topic Re: Getting the Expression name from a grouped Expression in QlikView

Getting the Expression name from a grouped Expression

Thu, 05 Apr 2012 14:21:16 GMT

Hi,

I have a chart which has two diffrent Expressions Grouped and kept as a cyclic expression against a Dimension, It has a Period as a Dimension and No of Apartments sold as one Expression and another one as Total Area Sold which is clubbed as a group and user uses teh cyclic button to select what he wants to see, where i am trying to show the selected expression in Chart Title , is this possible ? is there any function, i came across some function to show the cyclic dimension names , but is there any thing for Grouped expressions as well ? pls help me if you know this

regards

Jeswanth

Re: Getting the Expression name from a grouped Expression

natebrunner — Wed, 18 Jul 2012 15:37:22 GMT

I'm wondering the same thing.

Re: Getting the Expression name from a grouped Expression

Wed, 18 Jul 2012 15:50:53 GMT

Jeswant:

Title in the chart can be achieved by:

1. Check "Show in Title" in general tab of chart properties.

2. Keep default in the text box (<use first expression label>) below the title chart.

The same works for title in caption but in QV 11. I am not sure which build has to be there.

Kiran.

Re: Getting the Expression name from a grouped Expression

natebrunner — Wed, 18 Jul 2012 16:45:52 GMT

Here's my issue though. I have a line chart with 3 dimensions in 1 group. Likewise, I have 2 dimensions that are also in 1 group. This gives me the flip button for both.

Now, I'd like to set 2 different reference lines depending on the expression. In order to do this, I need to be able to grab the expression name like I can for dimensions in the function GetCurrentField(GROUP_NAME).

Is this not possible?

Re: Getting the Expression name from a grouped Expression

swuehl — Wed, 18 Jul 2012 16:57:08 GMT

I don't think you can easily retrieve the expression label.

Maybe John's suggestions posted here

http://community.qlik.com/message/8097#8097

can help you. Basically you create another dimension group that will determine the expressions you are using (pick() the right expression by calling GetCurrentField( Expression_Group ))

Hope this helps,

Stefan

Re: Getting the Expression name from a grouped Expression

fkeuroglian — Tue, 23 Jul 2013 01:55:54 GMT

please check this

hope help

Fernando

Re: Getting the Expression name from a grouped Expression

marcus_sommer — Tue, 23 Jul 2013 12:14:47 GMT

With a macro like this and with using from variables as expression is it possible:

sub ShowExpressionsName

set chart = ActiveDocument.GetSheetObject("CH01")

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionData

ActiveDocument.Variables("vExpression").SetContent expr.Definition.v,true

msgbox expr.Definition.v

end sub

Re: Getting the Expression name from a grouped Expression

mahesh_agrawal — Thu, 03 Jul 2014 12:51:34 GMT

Hi,

The window's title will get changed automatically based on selection of the expression. But this case is viable for all types of charts except Pivot and Straight Table.

Re: Getting the Expression name from a grouped Expression

Fri, 26 Sep 2014 04:45:32 GMT

Steps to show expression from Grouped Expression:

1) Enable Show title [ Chart Properties -> General -> Enable Show Title ]

2) Align Title to Left [ Chart Properties -> General -> Title Settings -> Left Horizontal Alignment ]

Hope this could solve your problem

Ramesh

Re: Getting the Expression name from a grouped Expression

sofiene_1920 — Fri, 12 Dec 2014 14:47:46 GMT

Bonjour,

Vous pouvez créer une table d'indicateur (ID, Expression_Name) et l'ajouter à votre model dans un premier stade.

Ensuite vous ajoutez un filtre d'expression dans votre dashboard, vous conditionnez l'affichage des expression par la sélection d'une expression dans ce filtre (ex : if(ID = 1 , sum(Chiffre),...)) ou bien dans le menu d'affichage conditionnel d'expression de l'objet (ID=1).

Enfin pour le titre vous mettez tous simplement : =Expression_Name

Si vous comptez activer plusieurs expression au même temps : = concat (Expression_Name, ' | ')

Cdt,

KMS

Re: Getting the Expression name from a grouped Expression

graziellas82 — Fri, 15 Mar 2019 10:09:55 GMT

This solution work for me.

Thanks