topic Re: QlikView Function Help in QlikView

QlikView Function Help

vanderson009 — Fri, 04 Apr 2014 04:34:46 GMT

Hello Community,

Anybody please explain me with example,

What is SecondaryDimensionality() and Dimensionality()

- Thanks in Advance

Villyee

Re: QlikView Function Help

sushil353 — Fri, 04 Apr 2014 04:42:30 GMT

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

Re: QlikView Function Help

arjunkrishnan — Fri, 04 Apr 2014 05:26:18 GMT

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

Re: QlikView Function Help

nizamsha — Fri, 04 Apr 2014 05:50:48 GMT

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