topic Re: Dynamic Titles in Charts in QlikView

Dynamic Titles in Charts

Tue, 26 May 2015 02:24:07 GMT

I have created a chart with cycling expressions. One expression shows the total time of some field. The other expression shows the average time of some field. I would like the title to be "Total Time" or "Average Time" depending on which expression is cycled.

So far, I have been unsuccessful in searching for a solution to this problem and the getfieldselection option doesn't seem to me to work here. Can someone please give me some insight into this problem? Thank you.

Re: Dynamic Titles in Charts

ecolomer — Tue, 26 May 2015 05:54:25 GMT

In the definition of Groups, you can write in the LABEL the name as you need show it

Re: Dynamic Titles in Charts

Anonymous — Tue, 26 May 2015 05:57:57 GMT

You may need to use the getcurrentfield() function in an expression for your label.

Help entry pasted below :

getcurrentfield (GroupName)

Returns the name of the currently active field in a group.

Example

getcurrentfield( myGroup )

Re: Dynamic Titles in Charts

Tue, 26 May 2015 06:06:55 GMT

Attaching the sample qvw with expected output.

You don't have to use any special functions to get the required results.

Re: Dynamic Titles in Charts

Tue, 26 May 2015 06:08:02 GMT

try something like this:

add a text box above your chart and try this expression

If(SubStringCount(GetCurrentField([cant-Imp]))>0,'Total Time','Average Time')

modify this expression as per your requirement

e.g

If(SubStringCount(right(left(trim(GetCurrentField([cant-Imp])),65),10),'Total Time')>0,'Total Time','Average Time')

Hope it helps

Re: Dynamic Titles in Charts

jonathandienst — Tue, 26 May 2015 06:09:50 GMT

Do you mean that you clicked the Group button on the Expressions tab? GetCurrentField only works for dimension groups AFAIK. If you create a label for each expression, the column header will change when you cycle. For a chart, if you enable "Show Title in Chart", the title will follow the cyclic label.

But I don't think that there is any way to get the cyclic expression label to the caption for a table..

Re: Dynamic Titles in Charts

Anonymous — Tue, 26 May 2015 06:15:17 GMT

... except if you use the getcurrentfield() function in a Caption expression.

Re: Dynamic Titles in Charts

Tue, 26 May 2015 11:42:41 GMT

Thank you for the responses and the file. My personal edition will not allow me to recover this file so I cannot see it.

Let me clarify my original question. I know how to label an expression. Please reference the two photos below. They are of the same chart. The first chart has an expression for the total time. The second photo shows the same chart cycled to show the average time. Notice that the title of the chart has not changed. This is what I want to update as the end user cycles the expressions.

Sorry for not being clear earlier.

Re: Dynamic Titles in Charts

Anonymous — Tue, 26 May 2015 12:30:59 GMT

Aaahhh !!! I think i understand the question now.

What I would do is give up with the expression cycle, and instead :

Create a Text Object with Actions to set a variable to say 'ExpA' or 'ExpB'
Make the 2 expressions conditional on the variable value.
Make a suitable Title expression using the variable value.