Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a group of values in a filter?


Hello everyone,

I have a field in my database with a several percentage values as you can see below:

média.PNG

As you can see the field has values with variance between 0% and 100%.

I would like to create a filter which displays the following values:

< 90%

> 90%

Anyone could help me to solve that?

Regards,

Rodrigo

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

You can create a Flag in your script..

If(Value >= 0.9, '>=90%', '<90%') as Flag

Where Value is your FieldName

View solution in original post

2 Replies
MK_QSL
MVP
MVP

You can create a Flag in your script..

If(Value >= 0.9, '>=90%', '<90%') as Flag

Where Value is your FieldName

sunny_talwar

Are these %ages coming directly from the database or are these based on a calculation? Can you share the expression if these are based on a calculation?