Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeF
Contributor II
Contributor II

Adding color to aggr expression

I have this expression that I pulled from another post and it is working in my app now.  How do you add color to this expression when the count >1.   Thanks/Mike

=aggr(
only({<[Estimate number]=>}[Estimate number])
& repeat(chr(160),16)
&num(
count({<[Estimate number]=>}DISTINCT [Job ID])
,'#,##0')
,[Estimate number])

 

MikeF_0-1662818586146.png

 

 

Labels (1)
1 Solution

Accepted Solutions
MikeF
Contributor II
Contributor II
Author

Thanks that worked perfectly!

View solution in original post

2 Replies
Rockstar7
Partner - Creator
Partner - Creator

@MikeF 

you can write text color expression using second expression in your logic

count({<[Estimate number]=>}DISTINCT [Job ID])

Rockstar7_0-1662894086745.png

 

 

Like this:

if((count({<[Estimate number]=>}DISTINCT [Job ID]))>1,green(),red())

 

MikeF
Contributor II
Contributor II
Author

Thanks that worked perfectly!