Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
JacobJones
Creator
Creator

Conditional colouring doesn't work for all numbers

 

Hi All,

I'm using this for conditional colouring

networkdays([Date Case Received] , [Date of Appointment]))
> 8 , '#15325a', '#59a14f')

It will work with other numbers, but if it is the number eight, it won't change the color

Any ideas, or this a bug?

 

Best,

Jacob

 

1 Solution

Accepted Solutions
JacobJones
Creator
Creator
Author

The issue was I wasn't rounding the results, I've included what ended up working:

 

=IF(ROUND(AVG({< [Date of Appointment] -= {""}, [Date Case Received]={">=$(=ONLY(vArthurStartDate))"}, [Service Name] = {"*CA"}>} networkdays([AxUDV_CaseTriage.Date Case Received] , [Date of Appointment]))) <= 8, '#59a14f','#15325a' )

 

 

View solution in original post

2 Replies
sugathirajkumar
Creator
Creator

networkdays([Date Case Received] , [Date of Appointment])) >= 8 , '#15325a', '#59a14f')

please try this

JacobJones
Creator
Creator
Author

The issue was I wasn't rounding the results, I've included what ended up working:

 

=IF(ROUND(AVG({< [Date of Appointment] -= {""}, [Date Case Received]={">=$(=ONLY(vArthurStartDate))"}, [Service Name] = {"*CA"}>} networkdays([AxUDV_CaseTriage.Date Case Received] , [Date of Appointment]))) <= 8, '#59a14f','#15325a' )

 

 

View solution in original post