Set Analysis - Ignore One Dimension - Problem

[#1]

Hi! First of all, sorry for my english.

This is my case:

I need to reach the sum ignoring one dimension. That Expression is called "_TEST"

I attach 2 images. (You must see the red color selection)

The first one, as you can see, have  952 as total value.

In the second one, i added one dimension. It is called: "LCCOSTOClienteGrupoCostoTIpoPFT".

I need that the Expression "_TEST" give me 952 for each value of that dimension.

So, i'm using: sum({$<LCCostoClienteGrupoCostoTipoPFT=>}MANIBultos) but it doesn't work.

Thanks

[oknotsen]

Hi,

Welcome to the Qlik Community.

Fieldnames in Qlik are Case Sensitive. Now compare your fieldnames:

- LCCOSTOClienteGrupoCostoTIpoPFT

- LCCostoClienteGrupoCostoTipoPFT

Notice the difference?

If you make sure the name you use in the Set Analysis statement is 100% exactly the same as the field name, your problem is most likely solved .

[swuehl]

Set analysis will be evaluated once per chart and can't be used to ignore dimensions. That's where you can make use of the TOTAL qualifier with a field list (listing the dimension fields you still want to consider):

Sum(TOTAL<Dim1, Dim2, Dim3> MANUBultos)

e.g. assuming the dimension fields are named like your dimension labels:

Sum(TOTAL<[Pccion Tipo],  Especie, Variedad, Envase, [Cte. Com. Grupo]> MANUBultos)

[#4 · Accepted solution]

Hi! You are right but the problem persist. It didn't change the results.

I don't know why

Thanks

[#5]

Hi! The problem with TOTAL and Dim1, Dim2, Dim3 is that in my app the dimensions selections are dinamic.

The end user can select which dimensions has to be shown in the pivot by a list box selection.

My problem persists.

Thanks

[swuehl]

Just use all possible dimensions in the field list of the TOTAL qualifier. Only the relevant ones (the ones dynamically selected by the user) will be used for the grouping.

[#7]

Yes! I could do it using GetFieldSelection!

Thanks