Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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.

1 Solution

Accepted Solutions
jontydkpi
Not applicable

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

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))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
jontydkpi
Not applicable

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

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))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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

Thank you Jonathan, It worked.

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