topic Re: Sum above values only when a dimension value is equal to the current one in QlikView

Sum above values only when a dimension value is equal to the current one

Anonymous — Thu, 27 Feb 2014 11:03:23 GMT

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

Value QUANTITY

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 ?

thank you

Re: Sum above values only when a dimension value is equal to the current one

datanibbler — Thu, 27 Feb 2014 11:06:31 GMT

Hi martinovedana,

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.

HTH

Best regards,

DataNibbler

Re: Sum above values only when a dimension value is equal to the current one

Anonymous — Thu, 27 Feb 2014 11:09:50 GMT

thanks DataNibbler but I can't do it during LOAD because it has to be dynamic based on current selections

Re: Sum above values only when a dimension value is equal to the current one

datanibbler — Thu, 27 Feb 2014 11:26:39 GMT

Hi,

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().