topic Access the Expression labels in an expression group in QlikView

Access the Expression labels in an expression group

Thu, 27 May 2010 17:00:05 GMT

HI,

I have a group of 3 expressions in a chart. I want to identify which expression the User is currently accessing so that I can set some other text etc on the same chart. Is there a way that I can right an if statement based on the label of the expression eg:

IF(ExpressionLabel = "xyz", Do something, Do something else)

Thanks in advance,

Pete Farmer

Access the Expression labels in an expression group

boorgura — Thu, 27 May 2010 18:12:14 GMT

Yes it is possible, but not directly.

In the chart properties - Enable show title in chart and let it <use first expression label>

You can align it to the right and get your cyclic icon right next to it.

But of course, for this to mean properly - You will just need to have just that one group or at least the group as the first expression.

Let me know if it works.

Access the Expression labels in an expression group

johnw — Sat, 29 May 2010 00:47:38 GMT

I hande this by creating a cyclic group instead of an expression group, then referencing getcurrentfield(group) in both the expression and anywhere else I need it. Attached is an example.

Access the Expression labels in an expression group

Sat, 29 May 2010 15:31:17 GMT

Hi John

Another amazing example what can be done with QV and your skills! Took me some time to figure out how you added that grouping.

Regards

Jürg