Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dcohen13
Contributor III
Contributor III

Conditional Formatting Not Working

Good evening!

I have the below dimension, that works great at outputting the desired text into the field. I should just be able to copy the same code into the Conditional Color background field, and replace the text with the color (Red(), Green()). But for some reason it's only working on some of the fields....Can anyone help me with my below code and tell me where it's wrong?

It's only coloring some of the fields, but outputting the right text

Thank you!!

 

-David

 

 

=
//If(Checkbox = 'Y' and No quotes are expired 'Release Checkbox' (Red)
IF([CheckBox.Price_Boolean] = 'Y' and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) >today(), 'Release Checkbox',

//If(Checkbox = 'Y' and quotes ARE expired, 'Update Quote' (Red),
IF([CheckBox.Price_Boolean] = 'Y' and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <=today(), 'Update Quote',

//If(Checkbox = 'N' and quotes are expired then 'Check Price box in Visual' (Red)
IF(([CheckBox.Price_Boolean] = 'N' or isnull([CheckBox.Price_Boolean]) )and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <=today(), 'Check Box in Visual',

//If checkbox = 'N' and no quotes are expired 'Pricing OK' (Green)
IF(([CheckBox.Price_Boolean] = 'N' or isnull([CheckBox.Price_Boolean]) ) and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) > today(), 'Pricing OK'))

//If(
//Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <=today(),'Issue',

//If( Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) >today()
//and [CheckBox.Price_Boolean] = 'Y',
//'Release Checkbox',

//If( Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <today()
//and [CheckBox.Price_Boolean] = 'Y', 'Fix Material Quotes')


))

 

Labels (1)
0 Replies