Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dimensionality Function and its types

Hi friends,

Can anybody helpme out what exactly is dimensionality and what that function does.. what are the types

I've gone through the manual but couldn't understand what it exactly does...

so please ensure that you say it in layman language with examples if possible as I'm very new to qlikview , so kindly do discuss it in detail.....

It would be a great help for me and would appreciate you time an concern in helping me out.....

Thanks a ton in advance



Tags (2)
2 Replies

Re: Dimensionality Function and its types


Dimensionality() indicates the level of subtotals in pivot tables. For example, if you have a pivot table with dimensions A, B, C  and D,

     the expressions will have a dimensionality of 5

     subtotals for D will have a dimensionality of 4

     subtotals for C will have a dimensionality of 3

     subtotals for B will have a dimensionality of 2

     subtotals for A will have a dimensionality of 1

     the grand total will have a dimensionality of 0

This allows you to tailor the expression to the return the correct value for the totals if you need something other than simple subtotals.

That said - this is fairly advanced concept. Try to understand the basics before diving into advanced aggregations and complex expressions.

Hope that helps


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Dimensionality Function and its types

Thanks JOnathan,

It would be a gr8 help for me if you can give example along, we are having group sessions where in which I was assigned with this topic ,which i need to research and present, so kindly help me out in briefing the same with example and the key purpose of this function.

Thanks for the helpful answer once again !!



Community Browser