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: 
ShahbazovT
Contributor III
Contributor III

count (val) / Total count (val)

Hi Experts.

There are a customer counts by utiliziation bucket, and I want to find share of  counts in each utiliziation buckets.

I use the following formula,  but I cannot get the desired result.  Please help.

Count(distinct(customer)) / count (distinct total(customer))

 

Capture.PNG

Labels (1)
2 Replies
QFabian
Specialist III
Specialist III

Hi @ShahbazovT , try this please :

Case 1:

Count(distinct MUSTERI_KODU) / count (distinct total MUSTERI_KODU)

 

Case 2 :

Count(distinct MUSTERI_KODU) / count (distinct total <Field for totalising> MUSTERI_KODU)

QFabian
ShahbazovT
Contributor III
Contributor III
Author

Thank you for support.

I have two dimension fields: Date, Utilization Bucket

and measure field: count of customers.

I tried  Count(distinct customer) / count (distinct total < Utilization Bucket> customer)*100

             Count(distinct customer) / count (distinct total < Date> customer)*100

              Count(distinct(customer)) / count (distinct total(customer))

but I didn't get what I wanted

Date and Utilization fields are corrected by the expressions