topic Re: Set Analysis - Ignore One Dimension - Problem in QlikView

Set Analysis - Ignore One Dimension - Problem

Thu, 26 Nov 2015 21:26:02 GMT

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

Re: Set Analysis - Ignore One Dimension - Problem

oknotsen — Thu, 26 Nov 2015 21:58:33 GMT

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 .

Re: Set Analysis - Ignore One Dimension - Problem

swuehl — Thu, 26 Nov 2015 23:17:12 GMT

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)

Re: Set Analysis - Ignore One Dimension - Problem

Mon, 30 Nov 2015 12:55:24 GMT

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

I don't know why

Thanks

Re: Set Analysis - Ignore One Dimension - Problem

Mon, 30 Nov 2015 12:58:02 GMT

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

Re: Set Analysis - Ignore One Dimension - Problem

swuehl — Mon, 30 Nov 2015 17:08:57 GMT

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.

Re: Set Analysis - Ignore One Dimension - Problem

Mon, 30 Nov 2015 18:51:55 GMT

Yes! I could do it using GetFieldSelection!

Thanks