Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation error

Hello All,

I have to calculate the INDICE as per the attached spreadsheet.

The formula is

=-(1-(TMT Pondéré/TMT Cible Pondéré)

However I need only the total to be calculated.

Any idea?

I tried different ways but I cannot find the solution.(even using variable)

I copied the expression i've used for all calculation in the first row.

Many Thanks,

Hasvine

8 Replies
bohravanraj
Partner - Creator II
Partner - Creator II

=-(1-(sum(TMT Pondéré) / sum(TMT Cible Pondéré))

Not applicable
Author

I tried but it doesn'y work. 😞

bohravanraj
Partner - Creator II
Partner - Creator II

Can you share QVW??

jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

=-(1-(sum(TOTAL TMT Pondéré) / sum(TOTAL TMT Cible Pondéré))


Regards,

Jagan.

Not applicable
Author

Hello Jagan.

It doesnt work as well.

It says expression ok but doesnt give any figure.

Thanks,

Hasvine

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you share your qv file?  Is the fields TMT Pondéré & TMT Cible Pondéré are numeric?

Regards,

jagan.

Not applicable
Author

No they are in 'hh:mm:ss' format.

I cannot share the QVW as it contain very sensitive data unfortunately. Lots of graphs. 😞

a_mullick
Creator III
Creator III

Hi,

Using an aggr() function should work for you. See the attached example - I've broken the columns down in the table just to see what is going on, but you can condense the whole thing into one expression.