# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Contributor III

## Calculate a value if greater than, with filter

Dear community,

I have to calculate the average of a list of values but only for the values that are greater than 480 (as an example).

Unfortunately I'm not able to finish it since i get an error after every solution I have tried until now.

I suppose that it should be something like:

=average(if(Column1>'480',({<[Column2]={"Good", "Super"}, .....>} [Column1]))

But it seems that I'm not allowed to use that filter ({<[Column2]={"Good", "Super"}, .....>} (without it is working).

Can someone help me here?

With best regards,

Gabriel

1 Solution

Accepted Solutions
Specialist III

Hi there,

I guess that you would want something like this:

=avg({<[Column2]={"Good", "Super"}, .....>} if(Column1 > 480, [Column1]) )

Can you try this way, I think the way you were trying to build the expression were wrong. Try my approach and tell me what happens.

Best regards,

MB

4 Replies
Specialist

Try

=avg({<Column2={'Good'}>}if(if(Column1>480,Column1))

Specialist III

Hi there,

I guess that you would want something like this:

=avg({<[Column2]={"Good", "Super"}, .....>} if(Column1 > 480, [Column1]) )

Can you try this way, I think the way you were trying to build the expression were wrong. Try my approach and tell me what happens.

Best regards,

MB

Contributor III
Author

Many thanks, it works!

Contributor III
Author

Thank you for the help, it would be a solution but there I think that is an additional if which should be taken out. If this is corrected then the solution works.

Tags
Community Browser