topic Re: Exclude values from the charts without set analysis in QlikView

Exclude values from the charts without set analysis

Fri, 28 Mar 2014 16:18:18 GMT

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.

Re: Exclude values from the charts without set analysis

MK_QSL — Fri, 28 Mar 2014 16:25:32 GMT

Set Analysis

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

If statement

IF(Status <> 1 , SUM(Sales)

Re: Exclude values from the charts without set analysis

rwunderlich — Fri, 28 Mar 2014 16:40:48 GMT

The if should be written as:

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

Re: Exclude values from the charts without set analysis

Josh_Good — Fri, 28 Mar 2014 16:46:03 GMT

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

Re: Exclude values from the charts without set analysis

MK_QSL — Fri, 28 Mar 2014 16:52:50 GMT

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

Re: Exclude values from the charts without set analysis

Fri, 28 Mar 2014 17:22:36 GMT

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.

Re: Exclude values from the charts without set analysis

Josh_Good — Fri, 28 Mar 2014 19:46:27 GMT

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.