expression for sum of particular column

[#1]

Dear All,

I am new to qlikview ,  i want to know expression to find the sum of particular column 'codes' in a table 'XX' starting from "31"..

Codes  Amount

3104      200

3145      200

3768      500

3183     700    

3333     222    

4444     400

3333     500    

3266     300

7890     4000

Regards,

Rahul

[qlikpahadi07 · Accepted solution]

Create a Expression Simply by :

sum({<Codes = {'31*'}>}Amount)