Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to make chart title/caption dynamic?

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!

1 Solution

Accepted Solutions
Highlighted
Champion
Champion

Re: How to make chart title/caption dynamic?

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.

View solution in original post

4 Replies
Highlighted
Champion
Champion

Re: How to make chart title/caption dynamic?

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' ))

Highlighted
Contributor III
Contributor III

Re: How to make chart title/caption dynamic?

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

Highlighted
Luminary
Luminary

Re: How to make chart title/caption dynamic?

Highlighted
Champion
Champion

Re: How to make chart title/caption dynamic?

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.

View solution in original post