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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
anjali1
Contributor
Contributor
‎2021-09-16 10:27 AM

Sum data with same ID

Hi everyone!

anjali1_0-1631801578087.png

The data in the image shows the Pump Unavailability (%)  for 3 different sites. I need to produce a table which sums the Pump Unavailability (%) for each site.  Eventually I want a table like this:

Site Id:         Pump Unavailability (%)

15553           31.45

15341           164.07

15002          21.39

Unfortunately, the Site Id and Pump Unavailability (%) data is in different tables. I did try to use a join function in the load script to join the tables, but it messed up my data.

Any suggestions on what to do? All help would be appreciated !

405 Views
1 Reply
Maria_Halley
Support
Support
‎2021-09-17 03:47 AM

@anjali1 

I will move this to the QlikView app development board. 

390 Views
0 Likes