Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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' ))
Hi I tried a nested if for all possibilities and it didn't seem to work
See my article.. if that helps
http://www.learnqlikview.com/how-to-display-dynamic-titles-in-qlikview/
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.