topic Re: Calculation error in QlikView

Calculation error

Fri, 04 Mar 2016 08:47:59 GMT

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

Re: Calculation error

bohravanraj — Fri, 04 Mar 2016 08:53:05 GMT

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

Re: Calculation error

Fri, 04 Mar 2016 08:55:19 GMT

I tried but it doesn'y work. 😞

Re: Calculation error

bohravanraj — Fri, 04 Mar 2016 09:01:21 GMT

Can you share QVW??

Re: Calculation error

jagan — Fri, 04 Mar 2016 09:01:58 GMT

HI,

Try like this

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

Regards,

Jagan.

Re: Calculation error

Fri, 04 Mar 2016 09:14:05 GMT

Hello Jagan.

It doesnt work as well.

It says expression ok but doesnt give any figure.

Thanks,

Hasvine

Re: Calculation error

jagan — Fri, 04 Mar 2016 09:24:57 GMT

Hi,

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

Regards,

jagan.

Re: Calculation error

Fri, 04 Mar 2016 09:28:08 GMT

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

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

Re: Calculation error

a_mullick — Mon, 07 Mar 2016 12:21:40 GMT

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.