Discussion Board for collaboration on QlikView Scripting.
Hi guys, I can't figure out how to sum above rows only when the rows have a field value equal to the current one.
Two dimensions: CAR and COLOR
Let's see the source table:
I'd like sum for eache row above quantity + current quantity only when color equals to the current one.is what I expect to obtain.
How can I obtain it with formulas ?
aggregate: Insert a sum([Quantity]) function in your LOAD.
=> Keep in mind you then need a GROUP BY clause encompassing ALL OTHER fields present in your LOAD.
thanks DataNibbler but I can't do it during LOAD because it has to be dynamic based on current selections
well, on the GUI, you could use a set_expression to sum up all the items grouped by (the user's current selection) which you can query using GETFIELDSELECTIONS().