Re: aggr (sum) - Qlik Community

Report Inappropriate Content · ‎2016-02-23

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 · ‎2016-02-23

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

tresesco · ‎2016-02-23

Yellow field has only a numeric value.

Report Inappropriate Content · ‎2016-02-23

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

Report Inappropriate Content · ‎2016-02-23

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

PrashantSangle · ‎2016-02-23

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2016-02-23

Hi,

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

PrashantSangle · ‎2016-02-23

Hi,

Use TOTAL Keyword

try like

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

REgards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

tresesco · ‎2016-02-23

May be,

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