Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sculptorlv
Creator III
Creator III

Complex count

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!

 

Labels (1)
2 Replies
zhadrakas
Specialist II
Specialist II

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

sunny_talwar

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?