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: 
ugurarslan
Creator
Creator

Count Distinct in an overdue balance aging

Dear all,

please see the table as following:

Aging Bucket
Company ID1-6061-9090 - 120120+
Apple$13$50$6
Peer$8$9$150$50
Banana$5$9
PineApple$5
Bag$7$8$8
Table$3

Dimension = Aging Bucket.

If I want to count how many company ID's have an overdue balance of 90 days I write this expression:

Count({<[Aging Bucket]={'90-120'}+{'120+'}>}distinct [Company ID])

Result = 6

But the result needs to be 4 Companies have an item on 90+.

Can you please help me writing the right expression?

Thanks

Ugur

1 Reply
adityaakshaya
Creator III
Creator III

Hi Ugur,

Please try like below.

Count({<[Aging Bucket]={'90-120','120+'}>}distinct [Company ID])

This will work for you.

Regards,

Akshaya

PS - If you find response Correct/Helpful then mark it as Correct/Helpful.