topic Re: Problem with total value in QlikView

Problem with total value

Tue, 01 Jan 2013 09:36:05 GMT

Hi All

I Have problem with the total value for this type of dimension:

In this picture :

X : Main Value

Y : Count Value

Z : X/Y

How can I hav total value for Z value??

tnx All

Atefeh

Re: Problem with total value

Tue, 01 Jan 2013 10:08:36 GMT

This is the result

beacause i have differnet value for "Y"

I want total for "Z"

Re: Problem with total value

Wed, 02 Jan 2013 05:15:02 GMT

go to properties of chart ---- > presentation ---> select field then check on show patial sum

now if Z is take as dimension then sum automatically show.

if Z take as expression then in your expression write sum(Z) or sum(total(Z)) .

thanks.

Re: Problem with total value

Wed, 02 Jan 2013 05:50:21 GMT

Hi,

U need to write expression like below

Z: sum(X/Y)

go to properties of chart ---- > presentation ---> select field(Z) then check on show patial sum

Regards,

Kabilan K

Re: Problem with total value

Fri, 04 Jan 2013 18:08:05 GMT

Thanks Kabilan K

Sorry for this delay

sum(x/y) is not true,Caz:

Result: sum(X1+X2+X3...)/sum(Y1+Y2+Y3+....)

but i need this result : sum((x1/y1)+(x2/y2)+(X3/Y3)+.....)

plz help me on this

Re: Problem with total value

wizardo — Sat, 05 Jan 2013 00:34:40 GMT

what you ask for is "sum of rows".

this can be simply done in a striaght table where you can change the "total mode" of the expression from "expressions Total" to "sum of rows"

a pivot table allways uses "expressions Total"

to do what yu need in a pivot table it is only posible by the use of the AGGR() function

the aggr functions take an expression as its main paramter and one or more dimensions as its other paramters

and reuren a set of values from the expr aggregated over the dimensions.

and then you can use SUM() to aggregate these values

what you need to do is use:

sum(aggr(sum(x/y) , yourdimension1,yourdimension2,yourdimension3))

since you have more then one dimension in yoru sample

you can use the

Dimensionality ( ) and Secondarydimensionality ( ) functions to

determine what level of the pivot is open and use an if expressions to set the expression with the relevent dimesnions

hope that helps

Wizardo

Re: Problem with total value

Sat, 05 Jan 2013 05:57:15 GMT

Tnx Wizardo

But That s not true

I want total value to use in the bar chart

but the value is not correct

please check my sample ,

maybe it can helpp you

Re: Problem with total value

wizardo — Sat, 05 Jan 2013 09:43:42 GMT

HI again

im sorry i was using X and Y as abstract example

when you use the aggr function you cannot use Column names that comes for the column names in the chart

you must use the actual names of the fields you are summing

like this

SUM(AGGR(SUM(Sale/Count),Year, Month,Branch,Type))

Re: Problem with total value

Sat, 05 Jan 2013 10:15:38 GMT

Completely True

Thanks alotttttttttttttt