Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Obviating a dimension in an expression of a pivot table

Hi all,
Do you know if you can tell an expression that group by one of the dimensions in a pivot table ?

My dimensions are , Agency , Campaign and Product and do not want to take into account in the expression the Product dimension , but the others.
I tried to put sum ( { < product = >} ContactosUtiles ) to join me useful contacts regardless of the product dimension does not work.

Thank you

6 Replies
MVP
MVP

Re: Obviating a dimension in an expression of a pivot table

Not sure, but may be this:

Sum(TOTAL <Agency, Campaign> ContactosUtiles)

Not applicable

Re: Obviating a dimension in an expression of a pivot table

I have also proven , but does not work .

Thank you

MVP
MVP

Re: Obviating a dimension in an expression of a pivot table

Would you be able to share a sample?

Not applicable

Re: Obviating a dimension in an expression of a pivot table

Hello Sunny T,

I give you an example:


Agency Campaign Product    ContactosUtiles

                                      P111

                      C11        P112

                                      P113

              ----------------------------------------------------------------------------------

                                      P121

    A1            C12        P122

              ----------------------------------------------------------------------------------

                      C13        P131

              ----------------------------------------------------------------------------------


I need to calculate the useful data regardless of the product dimension


I tried it with:

- Sum(TOTAL <Agency, Campaign> ContactosUtiles)

- sum ( { < product = >} ContactosUtiles )


but it does not work


Thank you

MVP
MVP

Re: Obviating a dimension in an expression of a pivot table

Hi,

Try like this

sum (TOTAL <product> ContactosUtiles )


Regards,

Jagan.

Not applicable

Re: Obviating a dimension in an expression of a pivot table

Hi jagan,

That would work if it were defined by ContactosÚtiles products.

ContactosÚtiles is not defined by products so I want to ignore this dimension.


Thank you.

Community Browser