How to make chart title/caption dynamic?

[Anonymous]

I'm trying to make a chart title dynamic based on the selection.

For instance if Total was selected it would say:

'Total Opportunity'

if Expected and Total were selected it would say:

"Expected vs Total Opportunity'

if all three were selected it would say 'Total vs. Expected vs. Won Opportunity'

I am new to QlikView looking for some suggestions. Thanks!

[YoussefBelloum]

Hi,

please find attached.

=if(vOutcomeView.Expected=1 and vOutcomeView.Won=1 and vOutcomeView.Total=1, 'Total vs. Expected vs. Won Opportunity',

if(vOutcomeView.Expected=1 and vOutcomeView.Total=1,'Expected vs Total Opportunity' ))

[Anonymous]

Hi I tried a nested if for all possibilities and it didn't seem to work

[shilpan]

See my article.. if that helps

http://www.learnqlikview.com/how-to-display-dynamic-titles-in-qlikview/

[YoussefBelloum · Accepted solution]

it is not working simply because your expression is wrong.

for your initial request i gave something working.

on every IF you should test the three variables.