Need help for an expression to get max message a person has received.

[#1]

Hello folks,

I am trying to create a qlikview app and I am stuck at a chart. Please help me. The requirement is to show maximum messages a person has received per category. I have three fields:  MSG_ID, Person_ID and Soruce which has two Values Med and Com.

I just need max messages one person has received in each source category.

I really appreciate all your help and suggestions.

Thank you,

Syed.

[jonathandienst · Accepted solution]

In two text boxes:

=Max(Aggr(Count({<Source = {'Med'}>} MSG_ID), Person_ID))

=Max(Aggr(Count({<Source = {'Com'}>} MSG_ID), Person_ID))

In table with Source as a dimension:

=Max(Aggr(Count(MSG_ID), Person_ID))

[#3]

Thank you Jonathan, It worked.

you guys makes Qlikview learning so much easier. appreciate it.