topic Re: Dimension in a specific expression in QlikView

Dimension in a specific expression

Anonymous — Mon, 23 May 2016 07:57:16 GMT

Hello

I would like to put the decomposition of a dimension in a Pivot Table where there are other dimensions:

Here the expression 'A' in the third line is composition by a other dimension names 'T'

How can i add the dimension 'T' in this Pivot Table with a '+' like the columns to see the decomposition ?

Thank you in advance for your help,

Sébastien.

Re: Dimension in a specific expression

swuehl — Mon, 23 May 2016 08:21:19 GMT

I am not sure I understand.

If you want to group by your expressions to a finer granularity, put the dimensions into the dimension tab.

You can pivot dimensions to the top or to the left, just as needed. If more than one dimension is available on the top / left of your chart, you can expand / collapse the columns / rows by using the small '+' button.

These dimensions will basically affect all expressions, stating a GROUP BY clause for your aggregations.

Re: Dimension in a specific expression

Anonymous — Mon, 23 May 2016 08:27:15 GMT

Thanks for your response but i would like to have the decomposition only on the expression 'A'.

Than is it possible to have '+' on the columns and the rows on the same time ?

Sébastien.