# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Contributor II

## Question re: conditional formatting in total column

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?

1 Solution

Accepted Solutions
MVP

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

2 Replies
MVP

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

Contributor II
Author

Thank you SO much!