Discussion Board for collaboration related to QlikView App Development.
I'm trying to make a chart title dynamic based on the selection.
For instance if Total was selected it would say:
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.
View solution in original post
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