Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ugurarslan
New Contributor

Count of selection in expression, unique value

Dear all,

I have a aging balance (outstanding amounts) which looks like the following.

Seller IDCar TypeOn HoldCurrentDue 1-30Due 31-60Due 61-90Due 91-120Due 120+
1456OpalYES $12.00 $-   $345.00 $-   $75.00 $-  
3478FerdNO $45.00 $-   $566.00 $664.00 $-   $-  
478382PirscheNO $-   $788.00 $7.00 $6,443.00 $-   $97.00
48392874OpalNO $-   $9.00 $8.00 $67.00 $7.00 $-  
247487OpalYES $87.00 $-   $99.00 $8.00 $-   $-  
47465HundaNO $789.00 $346.00 $6.00 $8.00 $7.00 $-  
3928094PirscheYES $80.00 $9.00 $54.00 $99.00 $-   $9.00
278479874OpalNO $-   $8.00 $6.00 $7.00 $89.00 $56.00

The question which I want to answer is:

How many Seller ID from the Car Type: Opal have an overdue balance which is over 90 days due.

The result which I expect to see is 2 (please see below which seller ID. ) I want to see the total of the unique seller id's.

Seller IDCar TypeOn HoldCurrentDue 1-30Due 31-60Due 61-90Due 91-120Due 120+
48392874OpalNO $-   $9.00 $8.00 $67.00 $7.00 $-  
278479874OpalNO $-   $8.00 $6.00 $7.00 $89.00 $56.00

The expression I write:

Count({<[Car Type]={'Opal'},[On Hold]={'No'},[AR Aging Bucket]={'Due 91-120'}+{'Due 120+'}>}[AMT USD]) doesn't give me the right answer.

Can you please help me what the right expression should be?

Thanks

Ugur

Tags (1)
7 Replies
MVP
MVP

Re: Count of selection in expression, unique value

How about this

Count({<[Car Type]={'Opal'},[On Hold]={'No'},[AR Aging Bucket]={'Due 91-120', 'Due 120+'}>}[AMT USD])

ugurarslan
New Contributor

Re: Count of selection in expression, unique value

This didn't work unfortunately....

MVP
MVP

Re: Count of selection in expression, unique value

Is it giving error or giving 0 or null as output?

ugurarslan
New Contributor

Re: Count of selection in expression, unique value

It didnt give the correct result. Sorry.

MVP
MVP

Re: Count of selection in expression, unique value

You don't have to be sorry for anything . But if you really need help, can you try to elaborate on what might be going on?

ugurarslan
New Contributor

Re: Count of selection in expression, unique value

Hi Sunny,

I created the following new question for you:

3 count questions for financial purposes.

Thanks for helping me.

Ugur

rangam_s
Contributor II

Re: Count of selection in expression, unique value

Try this.


Count({<[Car Type]={'Opal'},[On Hold]={'No'},[AR Aging Bucket]={'Due 91-120', 'Due 120+'}>}[Seller ID])