Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

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.

Milliarden.JPG

It should f.e. look like this.

2017.JPG

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.

Script.JPG

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

1 Solution

Accepted Solutions
Master II
Master II

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)


P.S: update your field instead of measure , dimension


Thanks,

Deva

View solution in original post

4 Replies
Master II
Master II

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)


P.S: update your field instead of measure , dimension


Thanks,

Deva

View solution in original post

Partner
Partner

Hallo Tom,

probier mal:

sum(if(Zeitkosten<10000000,Zeitkosten))

Creator
Creator

Perfekt, macht was es soll. Danke dir!

Creator
Creator

Method 1 worked great for me, thank you.