topic Question re: conditional formatting in total column in QlikView

Question re: conditional formatting in total column

Anonymous — Thu, 27 Sep 2018 16:24:10 GMT

All, in the chart below, I have the background for 'Dials' and 'Talk Time' set as

=if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)>=2.5,RGB(0,255,0),if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)<=1.9999,RGB(255,0,0),Yellow()))

This part is working as intended but I need the background expression to NOT apply to the total column. I need those to be white. How can I do this?

Re: Question re: conditional formatting in total column

MarcoWedel — Thu, 27 Sep 2018 18:44:17 GMT

Hi,

maybe you can try with:

=If(SecondaryDimensionality(),if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)>=2.5,RGB(0,255,0),if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)<=1.9999,RGB(255,0,0),Yellow())))

hope this helps

regards

Marco

Re: Question re: conditional formatting in total column

Anonymous — Fri, 28 Sep 2018 14:01:13 GMT

Thank you SO much!