Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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