Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dimension in a specific expression

Hello

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

Capture.PNG

Capture.PNG

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.

2 Replies
swuehl
MVP
MVP

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.

Anonymous
Not applicable
Author

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.