topic Complex count in QlikView

Complex count

sculptorlv — Sat, 16 Nov 2024 04:10:17 GMT

Hello!

I have the following tabel

Client_Number Client_Contract_Number Quantity

A 11 1

A 22 3

B 33 2

Clienta numbers are unique

Cleint contract number are uniques and also are conected to client number.

I need do get COUT(quntity) for each contract and COUNT(quantity) for each Client .

I can do it by two separated LOAD statments. Is it possible to get necessary COUNTS within one LOAD statement by showing some additinal parameters?

Thank you in advance!

Re: Complex count

zhadrakas — Wed, 24 Apr 2019 09:37:52 GMT

Hello,
by using Count(quantity) it will always break down to your deepest layer of dimensions.
you can set the TOTAL Qualifier Change that:
Count(TOTAL <Client_Number> quantity)
Count(TOTAL <Client_Contract_Number> quantity)

that Expression should do the trick for you.
regards
tim

Re: Complex count

sunny_talwar — Wed, 24 Apr 2019 11:33:02 GMT

first of all, you want to count the quantity or sum it?

Also, you are looking for this to be done in the script? in a single load aggregating over different dimensions? I don't think this is possible. Can you elaborate on the context of this thing. May be there is another way to do this?