Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dimensionality()

Can anybody explain in easy way, dimensionality() and secondarydimensionality() and when to use

pls paste some example if you hav any??

4 Replies
swuehl
MVP
MVP

Have you checked the 'examples of chart inter record functions' in the Help file? This contains examples of dimensionality() and secondarydimensionality().

Not applicable
Author

yes gone through the help file but didnt understand, can u post any example

swuehl
MVP
MVP

Dimensionality() and SecondaryDimensionality() can be used to determine in which type of line in a chart (Total / subtotal / detail) the expression is evaluated.

Thus your expression can 'react' on its context.

See attached for a sample.

[Take care in a pivot table, the outcome of Dimensionality / secondary dimensionality() is depending on your dimensions pivoted to the top or not, just play around to see what I mean]

Not applicable
Author

Good explanation.