topic Re: Color expression with multiple conditions in QlikView

Color expression with multiple conditions

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two columns with color expressions. I want to add a third column to turn green if the other 2 columns turn green. Any help? what i also did was to use the expressions for the two columns but i am getting an error when i use the expressions from the other two columns to set the color expression. Please see below.

=if((num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RequestedPartTimeFlag), '##0')>=sum(PTAppGoal)and

(num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} (RequestedFullTimeFlag-RequestedBothStatus)), '##0')>=sum(FTAppGoal),LightGreen(),Yellow()))

Thank you

Re: Color expression with multiple conditions

sunny_talwar — Mon, 02 Apr 2018 14:42:44 GMT

May be try this:

=If((Sum({$<ApplicationStatusCode -= {'DUPLAP'}, ApplicationDate = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RequestedPartTimeFlag) >= Sum(PTAppGoal)) and

(Sum({$<ApplicationStatusCode -= {'DUPLAP'}, ApplicationDate = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} (RequestedFullTimeFlag-RequestedBothStatus)) >= Sum(FTAppGoal)), LightGreen(), Yellow()))

Re: Color expression with multiple conditions

vishsaggi — Mon, 02 Apr 2018 15:02:39 GMT

Did you try Sunny's expr? If you still have issues can you share a sample file to look into?

Re: Color expression with multiple conditions

taylor_jesse — Mon, 02 Apr 2018 15:11:34 GMT

Hi Sunny,

This code worked fine but isn't the number formatting important in this case as it was used in the other columns?

Thank you

Re: Color expression with multiple conditions

taylor_jesse — Mon, 02 Apr 2018 15:12:55 GMT

Yes it did work but isn't the number formatting important in this case as it was used in the other columns?

Thank you

Re: Color expression with multiple conditions

sunny_talwar — Mon, 02 Apr 2018 15:13:16 GMT

Num() is not needed for if condition because num() is only a formatting function... if you want, you can add it back but it is really not needed. For me, the rule of thumb is... remove functions which are not needed...

Re: Color expression with multiple conditions

taylor_jesse — Mon, 02 Apr 2018 15:16:37 GMT

Make sense.

Thanks alot Sunny