Rookie about frequency and count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Excuse my limited q.v. knowledge. I got a table of data (50k+ rows)

Account name, Aging, Risk Category, Notional Amt, Start date

Ltfv, 13, Unconfirmed, $200, 05232018

Ltfv, 14, Unconfirmed, $200,05232018

Ltfv, 15, Unconfirmed, $200,05232018

Ltfv, 2, Unconfirmed, $450, 09162018

Ltfv, 3, Unconfirmed, $450, 09162018

Ltfv, 17, non receipt, $1000, 11282017

Ltfv, 18, non receipt, $1000, 11282017

Ltfv, 19, non receipt, $1000, 11282017

Ltfv, 27, non receipt, $1000, 11282017

Ltfv, 26, Unconfirmed, $150, 06112017

Ltfv, 27, Unconfirmed, $150, 06112017

Ltfv, 28, Unconfirmed, $150, 06112017

Ltfv, 29, Unconfirmed, $150, 06112017

Ltfv, 4, Unchecked, $330, 08232016

Ltfv, 5, Unchecked, $330, 08232016

Ltfv, 6, Unchecked, $330, 08232016

Ltfv, 7, Unchecked, $330, 08232016

Ltfv, 8 Unchecked, $330, 08232016

Glob, 18, non receipt, $240, 09222017

Glob, 19, non receipt, $240, 09222017

Glob, 20, non receipt, $240, 09222017

Glob, 21, non receipt, $240, 09222017

Each Account name case is differed by Notional Amt & Start date. I need to have a summary chart that ranks the Account name by Risk Category and Total count(Aging). E.g.

Daal relates to 3 different Risk Category (unconfirmed, non receipt and unchecked) so ranks top.

Expected result of top 30 table:

Rank, Account name, Risk Category, Total distinct count(Aging), Outstanding days

1, Ltfv, Unconfirmed, 3, 9 (because 3 + 2 + 4)

1, Ltfv, non receipt, 1, 11 (because from 17 to 27)

1, Ltfv, Unchecked, 1, 5 (because from 4 to 😎

2, Glob, non receipt, 1, 4 (because from 18 to 21)

Pls provide the QVW sample. Your help is much appreciated!!

topic Rookie about frequency and count in QlikView

Rookie about frequency and count