You could use something like the following for your dimension: =if(Sales >0 and Sales <>'' and Sales <> 'N/A',Month) Where 1. Sales is the filed you want to average 2. Month is your dimension Regards Rahul
I have tried your suggestions but neither appear to work within the parameters of my particular problem. I'm not quite sure why they do not appear to be working as on paper they should work.
Please find attached the Qlikview application where I am attempting to apply the condition to exclude the zeros.
You will see alongside the matrix 3 list boxes for each category. If I select the value excluding the zeros it corrects the averages, however if apply the filter to one category it also affects the other two categories in that it omits data some of which might have values which I would want to be able to incorporate into the finished matrix.