Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude values from the charts without set analysis

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.

6 Replies
MK_QSL
MVP
MVP

Set Analysis

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

If statement

IF(Status <> 1 , SUM(Sales)

rwunderlich
MVP & Luminary
MVP & Luminary

The if should be written as:

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

Josh_Good
Employee
Employee

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
MVP
MVP

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

Not applicable

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
Employee
Employee

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.