Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
karlykrebs
New 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
Esteemed Contributor

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
YoussefBelloum
Esteemed Contributor

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

karlykrebs
New 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

Luminary
Luminary

Re: How to make chart title/caption dynamic?

YoussefBelloum
Esteemed Contributor

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