Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist
Specialist

Try

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

Highlighted
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

Highlighted
Contributor III
Contributor III

Many thanks, it works!

Highlighted
Contributor III
Contributor III

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.