topic Re: Relative in expression tab in QlikView

Relative in expression tab

Wed, 16 Apr 2014 10:23:57 GMT

can any body tell me adv of relative property in expression tab

alexandros17 — Wed, 16 Apr 2014 10:25:19 GMT

Compute the % from your expression and total amount of the expression

Wed, 16 Apr 2014 10:27:04 GMT

can u please elobrate with example

jvitantonio — Wed, 16 Apr 2014 10:29:24 GMT

Hello Venu,

When you check this option, you'll see the % representation of the values over the total.

As an example if you have the following dimension/values:

A = 50

B = 20

C = 30

you'll get the following output

A = 50% (A represents 50% of the total values) = Value of A * 100 / Total values (which in this example is 100)

B = 20% ( B represents 20% of total values)

C = 30% (C represents 30% of total values)

I hope this helps.

alexandros17 — Wed, 16 Apr 2014 10:33:38 GMT

Month, Val

Jan, 10

Jan, 5

Feb, 15

Mar, 40

Apr, 25

Expression is Sum(Val), Dimension is Month

so you will see in your table:

Month, Val

Jan, 15

Feb, 15

Mar, 40

Apr, 25

If you add relative:

Month, Val

Jan, 15, 0.1578 (=95/15)

Feb, 15, 0.1578 (=95/15)

Mar, 40, 0.025 (=40/95)

Apr, 25, 0.2631 (=25/95)