Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
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?

PT chart.jpg

1 Solution

Accepted Solutions

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

View solution in original post

2 Replies

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

View solution in original post

Contributor II
Contributor II

Thank you SO much!