Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Ignore One Dimension - Problem

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

1 Solution

Accepted Solutions
Not applicable
Author

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

I don't know why

Thanks

View solution in original post

6 Replies
oknotsen
Master III
Master III

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 .

May you live in interesting times!
swuehl
MVP
MVP

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)

Not applicable
Author

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

I don't know why

Thanks

View solution in original post

Not applicable
Author

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
MVP
MVP

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.

Not applicable
Author

Yes! I could do it using GetFieldSelection!

Thanks