Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

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

View solution in original post

Highlighted
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.