topic Dimensionality () in QlikView

Dimensionality ()

NavinReddy — Sun, 28 Apr 2013 10:18:59 GMT

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

Re: Dimensionality ()

sushil353 — Mon, 29 Apr 2013 05:45:41 GMT

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

Re: Dimensionality ()

NavinReddy — Mon, 29 Apr 2013 07:23:29 GMT

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

Re: Dimensionality ()

jagan — Mon, 29 Apr 2013 08:34:42 GMT

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.

Re: Dimensionality ()

Mon, 29 Apr 2013 09:22:19 GMT

see this link

http://community.qlik.com/thread/59050