Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

14 Replies
arulsettu
Master III
Master III

try with

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

shraddha_g
Partner - Master III
Partner - Master III

Try

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

Anonymous
Not applicable
Author

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

devarasu07
Master II
Master II

Try like this,

Dimension:

Schadenannahme

Measure:

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

Anonymous
Not applicable
Author

That leads to --

Anonymous
Not applicable
Author

Also counts the zeros, didn't work as expected

Anonymous
Not applicable
Author

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
Master II
Master II

Hi,

Can you share your mock data. tks

Uploading a Sample

arulsettu
Master III
Master III

post the sample app