# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## aggr (sum)

Hello All,

I have a huge problem. In the attached excel is a table which i managed to re create in qlikview except column "temp sum".

In yellow you will find the formula.

Is there a way or a formula which I can use to calculate the same on qlikview.

Many Thanks,

Hasvine

8 Replies
Contributor II

## Re: aggr (sum)

Will you Please share the formula and what you want to achieve as I don't find any formula in excel

MVP

## Re: aggr (sum)

Yellow field has only a numeric value.

Not applicable

## Re: aggr (sum)

The formula in the yellow cell is : =-(1-(J12/K12))

Not applicable

## Re: aggr (sum)

The formula in the yellow cell is : =-(1-(J12/K12))

## Re: aggr (sum)

Hi,

I am not able to find formula column in attached excel.

Regards

Regards,
Prashant Sangle
Not applicable

## Re: aggr (sum)

Hi,

The formula in the yellow cell is : =-(1-(J12/K12))

## Re: aggr (sum)

Hi,

Use TOTAL Keyword

try like

-(1-(sum(total<dimen1,dim2> [TMT Pondéré])/sum(total<dimen1,dim2> [TMT Cible Pondéré])))

REgards

Regards,
Prashant Sangle
MVP

## Re: aggr (sum)

May be,

In a text box, = -(1-Sum(J)/Sum(K))