Solved: filter sum by number value - Qlik Community

kryan · ‎2021-07-13

Hello, I have a sum of costs in a table that is organized by project. I want to only display the sum of the cost if the total is below -5,000. Any suggestions on how to do this?

kaushiknsolanki · ‎2021-07-13

You can try simple method.

If(Sum(Cost)<=-5000,Sum(Cost))

You can also convert this into set analysis.

Sum({<Project = {'=sum(Cost)<=-5000'}>}Cost)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2021-07-13

You can try simple method.

If(Sum(Cost)<=-5000,Sum(Cost))

You can also convert this into set analysis.

Sum({<Project = {'=sum(Cost)<=-5000'}>}Cost)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!