topic How to get the used expression? in QlikView

How to get the used expression?

Thu, 01 Apr 2010 20:48:02 GMT

Hi All,

I hope someone already solved my challenge: I use a group of expressions like Sum(Qty) and Sum(Sales). Now I want to show certain other objects (e.g. credits or reference codes) only if the Sum(Sales) expression is shown in the first object. Does anyone know how to reference which of the grouped expressions is currently used?

Thank you all in advance!

Florian Kausler

How to get the used expression?

johnw — Thu, 01 Apr 2010 22:28:17 GMT

So far as I know, there is no way to reference the currently-selected expression from a group.

That said, you can fake it up by creating field names corresponding to the expressions, putting those field names in a group, and then referencing getcurrentfield(group) inside of a SINGLE expression in the chart. The behavior will be basically the same as grouped expressions, but now other objects can know which "expression" has been selected. Yeah, it's a workaround, but it works.

See attached example.

EDIT: Or not. That doesn't look like the right example. I have way too many examples on my hard drive. I'll try to find an appropriate example.

EDIT: I think I have the right example attached now. In the example, we reference the selected "expression" to change the sort order. But you can make the same reference in other objects as well.

Re: How to get the used expression?

pratap6699 — Mon, 22 Jun 2015 13:54:39 GMT

object right click-->expression-->group-->cyclic/dropdown-->use anynumber of expressions in group

Re: How to get the used expression?

jrdunson — Wed, 16 Nov 2016 16:24:25 GMT

John,

Hello,

just wanted to ask a questions on this... the illustration you give is for dimensions

What if I have cyclic expressions? Is there a way to show the labels for two cyclic expressions?

It defaults to <get first expression label> Is there a way to display both labels? (i.e. from my second expression?)

Re: How to get the used expression?

buzzy996 — Wed, 16 Nov 2016 16:33:40 GMT

see attached

Re: How to get the used expression?

jrdunson — Wed, 16 Nov 2016 19:53:55 GMT

Hey, thanks, but as I stated, you listed a way of seeing dimensional cyclic groups, not expression cyclic groups ...How can I get the name of the Expression Cyclic Groups?

Re: How to get the used expression?

johnw — Wed, 16 Nov 2016 20:25:54 GMT

I've probably misunderstood your question, since the default behavior is to show the label of both cyclic groups. Not as the "title in chart", but as the legend for your two cyclic expressions. I fiddled around in the attached to line up the cycle icons next to the expression label, but there were no special settings or anything.

Re: How to get the used expression?

jrdunson — Wed, 16 Nov 2016 21:00:17 GMT

Ok... thanks... I can just forego a chart title ...

Re: How to get the used expression?

johnw — Wed, 16 Nov 2016 21:08:29 GMT

I'm not your users, but I like it.

Re: How to get the used expression?

jrdunson — Wed, 16 Nov 2016 21:11:06 GMT

thanks again

Re: How to get the used expression?

Margaret — Fri, 31 Mar 2017 23:18:48 GMT

If you check 'Show title in chart' in General Tab, and leave textbox below that blank, the expression VALUE will display on the top of the chart, unless you have specified a LABEL for the Expression, then the LABEL for the expression will display at the top of the chart.

Cntrl + Shift + Click and drag will allow you to move that label around.

Re: How to get the used expression?

kashyapdhar — Sun, 16 Sep 2018 08:38:02 GMT

Hi,

The way john has explained works like a charm for multiple scenarios. The basic of how you can quickly and easily get the label and also add sorting mechanism to your charts for cyclic expressions is amazing. I have been using this in many of my reports deployed to end users and the functionality just keeps improving in different charts over time for me.