Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression Syntax

My data contains two columns: Amount and Category. The category column has three options: B, C, and O. I would like to add an expression that would only look at the sum for category "B" or "O" or both "B+O". I am looking for some help with the syntax

1 Solution

Accepted Solutions
MVP
MVP

Re: Expression Syntax

Maybe

sum(if(Category = 'B' or Category = 'O', Amount))

resp.

sum({<Category = {'B','O'}>} Amount)

1 Reply
MVP
MVP

Re: Expression Syntax

Maybe

sum(if(Category = 'B' or Category = 'O', Amount))

resp.

sum({<Category = {'B','O'}>} Amount)

Community Browser