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
shraddha_g
Partner - Master III
Partner - Master III

Provide your sample app

Anonymous
Not applicable
Author

Upload done, thank you.

Anonymous
Not applicable
Author

Upload done, thank you.

arulsettu
Master III
Master III

what is your expected output

Anonymous
Not applicable
Author

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.