Skip to main content

Qlik

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: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
212 Views
0 Likes
0 Replies