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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
Not applicable
‎2014-07-14 11:53 AM

How to use Aggr function in order to get desired results

Attached here Excel report I created from our ERP system using QlikView.

This report contains production reports per shift.

The ERP system does not manage shifts therefore the shift calculations should be done in Qlikview.

I tried to produce the desired report (as seen in the attached Excel file) in one calculation using Aggr function,

but I get only empty cell.

Does some one have an idea how to solve this problem (in one shot not without creating another table)?

Preview file
37 KB
265 Views
0 Likes
0 Replies