Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am calculating the average in Qliksense bar chart, this is the formula I'm using
Sum(Value)/Count((no of groups)), when I do this some of the averages are correct and some of the averages are incorrect, then I found that they are only taking into account values greater than 0. so I want to add a condition to my formula, to include values only that are greater than zero. Any help on this??
Hi @Qlikuser09 ,
If you only want to count Values that are greater than 0 you can add a set analysis to exclude 0's.
Sum({$<Value={">0"}>}Value)
Take in to account whatever is done in the numerator may have to be reflected in your denominator as well depending on your data structure.
Thanks
Anthony
Hi @Qlikuser09 ,
If you only want to count Values that are greater than 0 you can add a set analysis to exclude 0's.
Sum({$<Value={">0"}>}Value)
Take in to account whatever is done in the numerator may have to be reflected in your denominator as well depending on your data structure.
Thanks
Anthony