Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Averaging over Dimension not listed in Dimensions

Use the Aggr function.

Brg

//KArathorn

Community Browser