Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Contributor II

Re: Calculation error

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

Not applicable

Re: Calculation error

I tried but it doesn'y work. :-(

bohravanraj
Contributor II

Re: Calculation error

Can you share QVW??

MVP
MVP

Re: Calculation error

HI,

Try like this

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


Regards,

Jagan.

Not applicable

Re: Calculation error

Hello Jagan.

It doesnt work as well.

It says expression ok but doesnt give any figure.

Thanks,

Hasvine

MVP
MVP

Re: Calculation error

Hi,

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

Regards,

jagan.

Not applicable

Re: Calculation error

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
Contributor II

Re: Calculation error

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.

Community Browser