Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Exclude in Set Analysis

Hi

I want to exclude specific GL Codes from Invoice Amount.

For e.g.

sum({$<[GL Code]=E({'ABC',XYZ'})>}[Invoice Amount])

Any idea how I can achieve this?

1 Solution

Accepted Solutions
MVP
MVP

Exclude in Set Analysis

Try

=sum({$<[GL Code] -= {'ABC',XYZ'} >}[Invoice Amount])

and ignore the bug in the expression editor highlighting the minus equal as error.

2 Replies
MVP
MVP

Exclude in Set Analysis

Try

=sum({$<[GL Code] -= {'ABC',XYZ'} >}[Invoice Amount])

and ignore the bug in the expression editor highlighting the minus equal as error.

Not applicable

Exclude in Set Analysis

Worked. Thanks

Community Browser