Exclude values from the charts without set analysis

[#1]

Hi,

I want to calculate most of the charts by excluding certain transaction's status for example I do not want to include the revenue of the transactions in which status equals 1. Therefore I do not want to use set analysis for all the charts in my qlikview document. Is there a way to exclude these transactions from the calculations?

Thanks.

[MK_QSL]

Set Analysis

SUM({<Status -= {1}>}Sales)

If statement

IF(Status <> 1 , SUM(Sales)

[rwunderlich]

The if should be written as:

sum(IF(Status <> 1 , Sales))

[Josh_Good]

If you don't want to put this in your expression then you could do it in your selections. I'd recommend creating a button with an action.  This button would make a selection that excludes all transactions where Status = 1

[MK_QSL]

Ohh... Thanks Rob... Actually using Set Analysis a lot so simple IF statement is not even remembered... !!!

[#6]

Josh that would be a good idea. I can use it but if there is another method to exclude the status 1 from the charts by default. It will be more helpful for me.

[Josh_Good]

Your general options are

1. Don't bring the data into the data model

2. Exclude by expression (i.e. set analysis or an if-statement)

3. Exclude data by an expression.

Beside that I can't think of any other approaches.