Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

macaulay
Contributor

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:

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

Tags (2)
14 Replies
arulsettu
Honored Contributor III

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

try with

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

shraddha_g
Honored Contributor III

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

Try

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

macaulay
Contributor

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

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

devarasu07
Honored Contributor II

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

Try like this,

Dimension:

Schadenannahme

Measure:

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

macaulay
Contributor

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

That leads to --

macaulay
Contributor

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

Also counts the zeros, didn't work as expected

macaulay
Contributor

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

Here's what i want to express at all:

Dimension.JPG

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
Honored Contributor II

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

Hi,

Can you share your mock data. tks

Uploading a Sample

arulsettu
Honored Contributor III

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

post the sample app

Community Browser