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

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
LorenaGSaar
Contributor II
Contributor II

🎃Background color to filter

Hello!

I have one app which I do all my calcs in expressions (aggr for instance), and based on some conditions, I'm color coding with red, blue and green. So far, so good.

 

Now, the client wants to make a filter - so select results which are in red, blue or green.

As those conditions are a result from an aggr, how can I create a filter without changing anything on my script?

Is there any way?

 

Thank you! 🙂

 

LorenaGSaar_0-1643367151816.png

 

1 Solution

Accepted Solutions
brunobertels
Master
Master

Hi 

I guess you have a color mesure lookink like this : 

if(Mymesure>0,Green(),red()) 

Right ? 

Then add a filter object and this kind of mesure 

aggr( 

if(Mymesure>0, ' Group OK', ' Group KO') , your dimension for Calls targeted ) 

View solution in original post

1 Reply
brunobertels
Master
Master

Hi 

I guess you have a color mesure lookink like this : 

if(Mymesure>0,Green(),red()) 

Right ? 

Then add a filter object and this kind of mesure 

aggr( 

if(Mymesure>0, ' Group OK', ' Group KO') , your dimension for Calls targeted )