topic Display Active Group in Title in QlikView

Display Active Group in Title

Tue, 24 Aug 2010 19:09:22 GMT

Hi All,

Lets say I have a cyclic group such as Time that has used fields Year - Quarter - Month- Date. If I use this group in the chart I know the current Field being displayed gets displayed next to the cycle icon. Is there any way to also use this in the title, ie change the title from Revenue by Year to Revenue by Quarter when the user selects it.

Thanks,

Display Active Group in Title

rwunderlich — Tue, 24 Aug 2010 20:51:14 GMT

See function GetCurrentField().

='Current Field is ' & GetCurrentField(groupname)

-Rob

Display Active Group in Title

Wed, 25 Aug 2010 17:55:28 GMT

Hmm, that is almost what I need. What if my group is based on some expressions ie for Year I have the expression = Year(date_field). I have this labelled as Year in the group. Is there a way to display the label and not the actual expression?

Thanks,

Display Active Group in Title

montubhardwaj — Wed, 25 Aug 2010 18:09:34 GMT

While creating a group, you can give the desired label name to the fields/Expressions. So when you cycle it, you will get the Labeled name only in the title after using the function (as suggested by Rob) in Title in General tab.

Regards,

Sharma

Display Active Group in Title

Wed, 25 Aug 2010 18:16:30 GMT

I do have labels in my group specified already... but when I use GetCurrentField it returns the expression, not the label.

Display Active Group in Title

Wed, 25 Aug 2010 18:30:39 GMT

Ok, this idea is a little odd, but is seems to work. When creating the expression for each group item add a comment at the end:

=Year(date_field)
//Year

For the comment, use what you would want for your label (keep the label in place, because this does not replace normal label functionality). Then when you want to get the (fake) label of the selected group, use:

=SubField(GetCurrentField(Tester), '//', 2)

Display Active Group in Title

Wed, 25 Aug 2010 18:43:37 GMT

In my case, the group is created in the Expressions section (which is not having name). what could I could?

Display Active Group in Title

montubhardwaj — Wed, 25 Aug 2010 18:45:35 GMT

hi Miller,

Very interesting thought...

Kudos...!!

Display Active Group in Title

montubhardwaj — Wed, 25 Aug 2010 18:57:50 GMT

Hi Felmasri,

Give name ie Label to each expression and then group them. So when you cycle it around, the corresponding Title will appear on the graph.

Cheers,

Sharma

Display Active Group in Title

Wed, 25 Aug 2010 19:19:27 GMT

I do not want to see it just in the chart, but I would like to use the expression labels in titles.

Display Active Group in Title

montubhardwaj — Wed, 25 Aug 2010 19:51:33 GMT

Hi,

Please see the attached. Hope it is helpful.

If you want same text to appear on border of chart, then repace "test" with the same expression as in

"show title in chart".

Cheers,

Sharma