Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Here is the resulting table I would want:
Use the Aggr function.