partial sum question

Anonymous — Wed, 17 Jan 2018 09:01:00 GMT

hi guys,

in qlikview, how could I get the partial sum of some rows

for example, I need to calculate the sum of A, B and C but D

manythanks

Re: partial sum question

marcus_sommer — Thu, 18 Jan 2018 08:47:21 GMT

Do you really need A,B,C and D within a single object? The simplest way to get the result of A,B,C would to select them or to exclude all other values. Another way would be to use conditions within the dimension/expressions to exclude unwanted values like: sum({< dimension1 -= {'D'}>} value).

If it really should be within a single-object you could add within the script another grouping-dimension for dimension1 and apply the partial sums on this dimension. Also possible is to add an additional value of "Total" to your dimension1 and query then this value within the expression like: if(dimension1 = 'Total', expr1, expr2).

I suggest just to use the feature of selecting the wanted values ...

- Marcus

topic Re: partial sum question in QlikView

partial sum question

Re: partial sum question