Skip to main content

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 
Search instead for 
Did you mean: 
GabrielOtet
Contributor III
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
miguelbraga
Specialist III
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

View solution in original post

4 Replies
rupamjyotidas
Specialist
Specialist

Try

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

miguelbraga
Specialist III
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

GabrielOtet
Contributor III
Contributor III
Author

Many thanks, it works!

GabrielOtet
Contributor III
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.