Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sum two diff field values in charts

     .

How can I sum the requests and problems columns and show only one organization name for the aggregated result

Data:

Org idOrganization# Requests# Problems
1145 (AHS)36140
1145 (AHS) - 1.0634,3814,427,468

Expected output:

     

Org id
Organization# Requests# Problems
1145 (AHS)634,4174,427,608
1 Solution

Accepted Solutions
sunny_talwar

May be try this:

Dimension

Org id

Expression1

MinString(Organization)

and your other two expressions....

View solution in original post

2 Replies
sunny_talwar

May be try this:

Dimension

Org id

Expression1

MinString(Organization)

and your other two expressions....

Not applicable
Author

Thx Sunny