expression with values geater than dedicated value

[Vlad12]

Hi there, It's extremely simple in any programming language, but I cannot get how it define in qlik.

I have two columns: ID and Price. I want to show only IDs with prices which is greater than 150. I've read more then 10 topics in this community and found multistring guidelines. But I believe it should be extremely simple in qlik sense

Just smth like: 

sum(only(amount>=150))

but it doesn't work. Could you help me?

[Vlad12]

Thanks Omar,

it filtered but the chart broken. How can I just cut off all ids with prices below "150"?

the values have been counted, but I need other - remove all ids with value below 150

[Vlad12]

Thanks Marcus for useful information, but I just need to resolve this minor issue at this moment.

[Vlad12]

[marcus_sommer · Accepted solution]

Try: sum({< prices = {">=150"}>} prices)