topic Re: Explain the dimensionality function in qlikview for qlikview beginners in QlikView

Explain the dimensionality function in qlikview for qlikview beginners

Thu, 11 Apr 2013 17:25:49 GMT

Hi,

I am penchalaprasad.I have completed Bachelor of technology in the stream of computerscience and engineering.After that i have completed my course in qlikview11.Right now i am preparing for interviews.I would like to understand and use the dimensionality function.I had gothrough the QLIKVIEW 11 reference manual,google,qlikview community and the book(QLIKVIEW 11 for developers).I had put a good effort to understand the dimensionality() by searching in the above mentioned 4.but i didn't understand any thing in these.Can anyone please help me by explaining the dimensionality function(like What is dimensionality(),Where we use it,when we use it,why we use it,how to use it)With a best example as early as possible.

Thanks in advance.

Re: Explain the dimensionality function in qlikview for qlikview beginners

Thu, 11 Apr 2013 18:24:38 GMT

If you go into Help within the Qlikview application and do a search on Dimenionality you will find a helpful explaination and examples.

This is true for all funtions and features within Qlikview.

Re: Explain the dimensionality function in qlikview for qlikview beginners

Fri, 12 Apr 2013 10:00:12 GMT

Before to start this discussion, i already search in the HELP.But i didn't understand anything about dimensionality().Tell me any other source

Re: Explain the dimensionality function in qlikview for qlikview beginners

sohailansari201 — Tue, 09 Jun 2015 20:03:06 GMT

You should find good information here:

How to use - Dimensionality()

Re: Explain the dimensionality function in qlikview for qlikview beginners

petter — Tue, 09 Jun 2015 22:31:09 GMT

Dimensionality() returns the number of dimensions that is visible (not collapsed) at the current row.

Another way of looking at it is that Dimensionality() returns the aggregation level which the current row in your chart is at.

It is a number starting at 1 and going upwards - except for partial sums in a pivot table that is 0.

The highest aggregation is 1 (except for partial sums or totals) that is when all rows for the leftmost column is collapsed.