Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ugurarslan
New Contributor

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

Tags (2)
1 Reply
adityaakshaya
Contributor III

Re: Count Distinct in an overdue balance aging

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.