topic How to conditional formatting with multiple conditions in QlikView

How to conditional formatting with multiple conditions

paul_ripley — Sat, 16 Nov 2024 01:26:07 GMT

Hello

I have a table with a variance column which is just the Actual - Budget columns. I have done a conditional formatting statement which works for the text colour

=IF(([Total actual YTD]-[Budget YTD]) /[Budget YTD] < 0, vGreen, vRed)

But if the income lines are the the other way round the expense lines if a negative income line should be red. The dimensions are part of a value list so i tried the below but I get errors. Can you please help

=If(ValueList($(vValueList_FMProfit)) = 'Third-party Fee Income',

IF(
([Total actual YTD]-[Budget YTD])

/[Budget YTD] < 0, vGreen, vRed)

IF(
([Total actual YTD]-[Budget YTD])

/[Budget YTD] > 0, vGreen, vRed)

)

Re: How to conditional formatting with multiple conditions

Brett_Bleess — Wed, 19 Feb 2020 21:15:45 GMT

Paul, quick question for you, does that variable by chance have a variable in it? If so, that could be the issue, as nesting variables is not a good idea, as there is no way to know the sequence of what is going to calculate when, so you may get unexpected results from things. Sorry I am not more help, this will kick things back up, so someone else smarter than I am may see things and have some other suggestions for you. Might be better if you can attach sample app too, as that generally does help in these situations as folks can play with things directly that way.

Regards,
Brett