topic Re: Question on TOTAL function in QlikView

Question on TOTAL function

gandelr — Tue, 03 Sep 2013 16:16:07 GMT

Hy I have three dimension

dim1

dim2

dim3

in a pivot table I want to create an expression total that does not include dim3

I write SUM(TOTAL <dim1,dim2> value)

My question is,

you can create a dynamic expression that allows me to always exclude the dim3 even if I add a new dimension.

For example

If i insert in the pivot a new dimesion (dim4) i make modify the expression SUM(TOTAL <dim1,dim2,dim4> value).

I would like to create an expression that shows me all values except dim3 regardless of the dimesion entered.

Re: Question on TOTAL function

swuehl — Tue, 03 Sep 2013 16:28:11 GMT

You should be able to add more field to the TOTAL field list, fields that are currently not a dimension. It shouldn't change the outcome of the aggregation. Then, after adding a listed field as dimension, the field in the field list should get effective (as for also for a dimension group).

Above method should also help you with conditional dimensions.

Not sure if this answers your question or helps you with your original issue. I don't think there is an easy way to get a list of the dimension fields (except using Macros).

Re: Question on TOTAL function

simondachstr — Tue, 03 Sep 2013 17:07:37 GMT

In addition to what swuehl suggested, maybe in this particular case something in the direction of sum(total value) - sum(<dim3> value) might be a clever solution.

Re: Question on TOTAL function

gandelr — Thu, 05 Sep 2013 12:48:24 GMT

thanks a lot I solved making a difference (sum(total value) - sum(<dim3> value) )