Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try with
if(len(trim(Schadenannahme))=0,count(Schadenannahme),0)
Try
Count({<Schadenannahme= {">0"}>}Schadenannahme)
I get the same result as before, the zeros are also counted.
Try like this,
Dimension:
Schadenannahme
Measure:
Count({$<Schadenannahme={"=Len(Trim(Schadenannahme))>0"}>}Schadenannahme)
That leads to --
Also counts the zeros, didn't work as expected
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.
post the sample app