Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ghosh612
Contributor
Contributor

How do I find the total of a Matching String's related field

I have this problem and I am trying to find a way for this, below is my data:


0683p000009M9cG.jpg

 

The case is, how do i find Nick Crebassa's total call length.

 

This is what I am trying to do with tmap and taggregaterow: Sum of 'Call Length in minutes', Where Customer Name=="Nick Crebassa", 

 

thank you.

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

You want to find sum of call length only for "Nick Crebassa" ? Then you can do filter before taggregaterow.

View solution in original post

4 Replies
manodwhb
Champion II
Champion II

Use taggregaterow and do group by costomername and do sum on call length in minutes and if you want to convert to hours then use tampons or tomorrow to convert sum of call length in minutes/60 .
Ghosh612
Contributor
Contributor
Author

but what about Group by Customer Name where Name == "Nick Crebassa"? Where do I use the expression?

manodwhb
Champion II
Champion II

You want to find sum of call length only for "Nick Crebassa" ? Then you can do filter before taggregaterow.
Ghosh612
Contributor
Contributor
Author

Thank you, this works. Understood how the grouping works.