This content has been marked as final. Show 3 replies
You can do that in a very similar way to SQL, using
using then GROUP BY clause, although I would use a graph (either a striaght or pivot table) to show more accurate results unless you already have a complex/stored procedure in your data source computing that total (which seems difficult to me as you are creating that field in QlikView).
LOAD ... , Sum(RepeatCounter2) AS TOTAL
Hope that helps!