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

[Anonymous]

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:

If ( (Schadenannahme) > 0, Count(Schadenannahme) ,0).

"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.

Thanks for the answers,

Regards

I uploaded part of the app for example

[arulsettu]

try with

if(len(trim(Schadenannahme))=0,count(Schadenannahme),0)

[shraddha_g]

Try

Count({<Schadenannahme= {">0"}>}Schadenannahme)

[Anonymous]

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

[devarasu07]

Try like this,

Dimension:

Schadenannahme

Measure:

Count({$<Schadenannahme={"=Len(Trim(Schadenannahme))>0"}>}Schadenannahme)

[Anonymous]

That leads to --

[Anonymous]

Also counts the zeros, didn't work as expected

[Anonymous]

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.

[devarasu07]

Hi,

Can you share your mock data. tks

Uploading a Sample

[arulsettu]

post the sample app