Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Averaging over Dimension not listed in Dimensions

1.  I have a table with the following field: Date, Order#, BO, Lines.

2.  I want to sum up number of BO's and Line's over Order# and Date; I also want to take the percent sumBO/sumLines

3.  I then want to take the average of sumBO/sumLines over all dates (ignoring Order#).

I was able to do all but the third line.


Can someone help.

Example Attached.

Here is the resulting table I would want:

DateAverage(SumBO/SumLines)
6/1/201321%
6/2/201323%
1 Reply
Not applicable
Author

Use the Aggr function.

Brg

//KArathorn