QlikView Function Help

[vanderson009]

Hello Community,

Anybody please explain me with example,

What is SecondaryDimensionality() and Dimensionality()

- Thanks in Advance

Villyee

[sushil353]

Hi

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

Please find attached

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 it

HTH

sushil

[arjunkrishnan]

Hi Villyee,

Primary Dimension - Is Main Dimension in chart(It's Work Expression Lable (Show In X or Y - Axis))

Secondary Dimension Splited Base On Primary Dimension Woking Like Lable...

Here Attach One Qvw It's Very Helpful For u

Regards By

ArjunKrish

[nizamsha]

customer is a dimension and  sum(Amount) as Measures

Amount is slicing based on the customer

if u have 3 dimension eg

customer ,product, Somtthng else not realated to cutomer but related the vendor

now if u use the function dimensionality(customer) mean it will show only customer only these two dimension will slice the measure  

Based on only customer and product dimension u r getting the measure