I have a question about counting costs. I got a excel row with costs per object. The problem is that from some objects the costs is "unknown". I want to som up the costs in Qlikview, but it gives errors because in the same row there are also "unknown" factors, not just numbers.
Do you want to sum it up or count it? If you use sum(), it should be able to sum the numeric values excluding the texts/strings by default. If you want to count the values excluding 'unknown' values, you could try using set analysis like:
