topic Problem with counting the avarage in QlikView

Problem with counting the avarage

Anonymous — Thu, 05 Nov 2015 14:42:04 GMT

Hi,

I have 2 contracts : 7000000012 and 7000088270

These contracts are within different periods with some revenue connected with them:

7000000012 - 15-01 till 15-09

7000088270 - 15-01 till 15-04

I was counting the average using analysis and divisor like this for one contract :

=Count(distinct([Rok-Miesiąc]))

For the first one result will be 9, for the second will be 4.

So for 7000000012 whole revenue will be divided by 9

and for contract 7000088270 will be divided by 4.

But what if I choose 2 contratcs at the same time ?

It will be problem because my divisor will be 9 (because we have 9 rows for contracts)

Contract 7000000012 should be still divided by 9 but contract 7000088270 should be divided by 4 because this contract
is not null only for months 15-01 till 15-04.

Maybe you have any solution for this ?

Thank you very much for your help,

Jacek Antek

Re: Problem with counting the avarage

sunny_talwar — Thu, 05 Nov 2015 15:29:19 GMT

May be this is what you are looking for:

=Count(DISTINCT TOTAL <ContractFieldName> [Rok-Miesiąc])

Re: Problem with counting the avarage

alexandros17 — Thu, 05 Nov 2015 16:24:56 GMT

Try to aggr by contract ...

let me know

Re: Problem with counting the avarage

Anonymous — Fri, 06 Nov 2015 14:54:22 GMT

Hi,

thank you for your answers.

Problem is that instead of contracts there could be more fields like contracts (with null), for example

Business units, companys, controlling objects etc.

So the answer would not be that easy...

It should be something counting not nulls under condition [Rok-Miesiąc].

Thank you in advance,

Jacek Antek

Re: Problem with counting the avarage

Anonymous — Mon, 09 Nov 2015 09:38:11 GMT

Maybe Count(distinct([Rok-Miesiąc], not null()))

Question is how to do condition not null in set analysis?

thank you for your answers,

Jacek Antek