This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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