topic Re: Count costs in QlikView

Count costs

nickploeg1998 — Wed, 25 Nov 2020 16:16:04 GMT

Hii,

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.

Lets hope someone can help me.

Re: Count costs

tresB — Mon, 01 Apr 2019 09:43:08 GMT

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:

Count(distinct {<cost-={'unknown'}>} cost)

Re: Count costs

nickploeg1998 — Mon, 01 Apr 2019 09:47:01 GMT

If I put that comment in Qlik it gives me a error

Re: Count costs

tresB — Mon, 01 Apr 2019 10:27:27 GMT

Could you share a screen shot of the error along with the expression for better understanding?

Re: Count costs

nickploeg1998 — Mon, 01 Apr 2019 12:30:57 GMT

Re: Count costs

tresB — Mon, 01 Apr 2019 12:43:38 GMT

Your field names seems to have space in between. Try putting [ ] around your field name in the expression.