topic Re: aggr (sum) in QlikView

aggr (sum)

Tue, 23 Feb 2016 07:56:05 GMT

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

bohravanraj — Tue, 23 Feb 2016 08:08:02 GMT

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

tresB — Tue, 23 Feb 2016 08:11:51 GMT

Yellow field has only a numeric value.

Tue, 23 Feb 2016 08:13:33 GMT

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

Tue, 23 Feb 2016 08:13:44 GMT

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

PrashantSangle — Tue, 23 Feb 2016 08:14:14 GMT

Hi,

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

Regards

Tue, 23 Feb 2016 08:14:47 GMT

Hi,

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

PrashantSangle — Tue, 23 Feb 2016 08:19:04 GMT

Hi,

Use TOTAL Keyword

try like

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

REgards

tresB — Tue, 23 Feb 2016 08:30:13 GMT

May be,

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