14 Replies Latest reply: Nov 16, 2017 5:57 AM by Tom Müller

# Create Count() Dimension, where Zeros aren't counted

Dear all,

one more question of me as a pure beginner. But at first let me just say thank you for your great help, I never experienced a better community than the Qlik Community.

I want to create a dimension, that counts the quantitiy of a value (the values are different, but I just need do differenciate between zero or not), but just the ones that aren't zero. What I tried was the following expression:

"Schadenannahme" is the dimension of the value.

As I use this created dimension for a measurement, there's no result, just --- .

Probably I did kind of a beginner's mistake, but I'm not really sure if and how to use the if- function in this.

Regards

I uploaded part of the app for example

• ###### Re: Create Count() Dimension, where Zeros aren't counted

try with

• ###### Re: Create Count() Dimension, where Zeros aren't counted

I get the same result as before, the zeros are also counted.

• ###### Re: Create Count() Dimension, where Zeros aren't counted

Try

• ###### Re: Create Count() Dimension, where Zeros aren't counted

Try like this,

Dimension:

Measure:

• ###### Re: Create Count() Dimension, where Zeros aren't counted

Also counts the zeros, didn't work as expected

• ###### Re: Create Count() Dimension, where Zeros aren't counted

Hi,

Can you share your mock data. tks

• ###### Re: Create Count() Dimension, where Zeros aren't counted

Here's what i want to express at all:

That's the measure, I would like to know, what's the average value of "Schadenannahme". As there are a lot values=0, I don't want them to be counted with.

• ###### Re: Create Count() Dimension, where Zeros aren't counted

post the sample app

• ###### Re: Create Count() Dimension, where Zeros aren't counted

The output shall be "Sum of values of "Schadenannahme"/number of (unlike zero) values".

So i want to know, how high the amount of one "Schadenannahme" is in average.