Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
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
bohravanraj
Partner - Creator II
Partner - Creator II

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

tresesco
MVP
MVP

Yellow field has only a numeric value.

Not applicable
Author

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

Not applicable
Author

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

PrashantSangle

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 🙂
Not applicable
Author

Hi,

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

PrashantSangle

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
MVP
MVP

May be,

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