Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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!