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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Dimensionality ()

Hi All,

Can Some plz explian me

What is Dimensionality(),How can we know in Expression level using dimensionality()

Give one Exmple with one realtime secnario

Thanks in Advance

Niranjan

4 Replies
sushil353
Master II
Master II

Hi Niranjan,

Dimensionality() fucntions gives you the no of dimensions present in the chart which are non aggregated form.

using this function you use the no of dimensions in your expressions.

In the qlikview help a descent example is given for dimensionality.

HTH

Sushil

NavinReddy
Creator II
Creator II
Author

Hi Sushil ,

Thanks a lot its helpful for me,

That examples some what confusion ,can u share if u have any examples

Thanks & Regards

Niranjan

jagan
Partner - Champion III
Partner - Champion III

Hi Niranjan,

Dimensionality() helps in knowing the level to which the Pivot table is expanded, you can check this in Pivot table with multiple dimension and an expression with

=Dimensionality()

If you minimize all the dimensions then the Dimensionality() will return 1, If you expand by clicking the + icon, then Dimensionality value for rows are updated.

Hope this helps you.

Regards,

Jagan.

Not applicable