Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
karlykrebs
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
YoussefBelloum
Champion
Champion

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
YoussefBelloum
Champion
Champion

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

karlykrebs
Contributor III
Contributor III
Author

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

shilpan
Luminary Alumni
Luminary Alumni

YoussefBelloum
Champion
Champion

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.