# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Exclude specific value from dimension

Dear QLIK Community,

I have a dimension, that emits costs of time. As the original source isn't that properly designed, there are some values, that shouldn't be included. When they are included, by evaluation looks like this.

It should f.e. look like this.

The above seen value (3.543.799.680€) appears just once, so what I want to do is exclued all values, that are higher than 10.000.000€.

My idea was to design the dimension like this.

As it can be seen, the false value is exluded, but the dimension isn't summed up anymore at the top. How can I design my dimension, so that the value is excluded but it furhtermore sums up the rest values?

Thanks for the replies.

Best regards,

Tom

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Honored Contributor II

## Re: Exclude specific value from dimension

Hi,

try below method,

Method 1:

try to create calculated dimension like below,

if ( sum(measure) < 10000000, dimension)

after that try to un-check that "Suppress Null Value" option in this Calculated dimension

Method 2: using set analysis //best approach

sum( {\$<measure = {">10000000"}>}measure)

Thanks,

Deva

4 Replies
Highlighted
Honored Contributor II

## Re: Exclude specific value from dimension

Hi,

try below method,

Method 1:

try to create calculated dimension like below,

if ( sum(measure) < 10000000, dimension)

after that try to un-check that "Suppress Null Value" option in this Calculated dimension

Method 2: using set analysis //best approach

sum( {\$<measure = {">10000000"}>}measure)

Thanks,

Deva

Partner

## Re: Exclude specific value from dimension

Hallo Tom,

probier mal:

sum(if(Zeitkosten<10000000,Zeitkosten))

Contributor

## Re: Exclude specific value from dimension

Perfekt, macht was es soll. Danke dir!

Contributor

## Re: Exclude specific value from dimension

Method 1 worked great for me, thank you.