Set analysis-How to only show results greater than a certain value

[paul_ripley]

Hello

The set analysis below produces the table below.

I would only really like to show any portfolio where the amount is greater than 500,000 ie rounded to the nearest 1million,

I would like to do this in set analysis as I would need to reproduce in N Printing as a formula

sum({< proceeds = {"Proceeds"}>} [GPR GBP])*-1

Would anyone be able to help with this?

Many thanks

Paul

[paul_ripley]

oh let me check,might be a spelling mistake

[paul_ripley]

Yes thanks for your help Sunny (I just had to change business to bussline.

Thanks you've helped me a lot and I am very grateful!

[paul_ripley]

Sorry another question, would you know why when I put this formula into N Printing it comes out as 1327000000, but it works in QlikView?

[sunny_talwar]

Do you have selections in QlikView dashboard?

[paul_ripley]

Yes I think that's it.  Many thanks.  You're a star!