topic Dynamic chart titles based on cyclic expressions. in QlikView

Dynamic chart titles based on cyclic expressions.

Mon, 23 Nov 2015 19:54:18 GMT

Hi,

I have five different expressions, which I made it into one cyclic expression:

1) sum(Fee)

2) sum(Principal)

3) Sum(Principal)/Sum([Total Issuances])

4) If([%Campaign Type] = 'Email', Sum([Unique Issuances])/Sum([Unique Sent]), Sum([Unique Issuances])/Sum([Unique Open]))

5) Sum(Fee)/Sum([Total Issuances])

And would like to make the title of the chart dynamic with respect to the selection. Any idea or sample code to illustrate this example?

Thanks in advance.

Regards,

Sachin

sunny_talwar — Mon, 23 Nov 2015 19:56:11 GMT

I don't think this functionality is currently available in QlikView.

JonnyPoole — Mon, 23 Nov 2015 21:19:45 GMT

i agree. It may be easier to do this with 5 different measures and each has a show/hide condition based on a list box value..

in the load script, create a new table with the names of your measures

load * inline [

MeasureName

measure1

measure2

measure3];

then add a list box for measurename in the UI

select one value in the list box

then enable 'only one selected value' in the properties of the list box

then on each measure in the chart, add a new show/hide condition:

Only(MeasureName) = 'measure1'

Only(MeasureName) = 'measure2'

etc...

Its not a cycle but the user can select any measure they want to show and you can use the same expression to show a different title or text...