how can I display sum of rows in the expression

[#1]

Salesorder item amount
121853 10 1
121853 20 1
121853 30 1
121853 40 1
121853 50 1
121853 60 1
121853 70 1
121853 80 1

I would like to findout how many items are having the value >=30 the amount should be shown 6

sumof rows needs to displayed in the expression

count(if(item >='30',Salesorder))

sum of row is displaying value

For reporting

Salesorder oneitem twoitem morethan3 item

121853 1 1 6

I need to display in the chart .

Advance thanks for your help.

[sczetty]

I suggest a simple if test:

if(item >= 30,1,null())

When you use this calculation, the result of the column will be the count of the qualifying items within your sales order.

[gmaguina]

You can use search with Set Analysis (version 8.5 or greater) to find those values >=30 :

count( {$<item = {">=30"}>} amount )

Good luck !

Gerardo

[#4 · Accepted solution]

Thanks.

I don't have Qlikview8.5 above version.Set analysis will work above 8.5 only right

[#5]

Thanks.I tried this - it didn't work