Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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.
=-(1-(sum(TMT Pondéré) / sum(TMT Cible Pondéré))
I tried but it doesn'y work. :-(
Can you share QVW??
Try like this
=-(1-(sum(TOTAL TMT Pondéré) / sum(TOTAL TMT Cible Pondéré))
It doesnt work as well.
It says expression ok but doesnt give any figure.
Can you share your qv file? Is the fields TMT Pondéré & TMT Cible Pondéré are numeric?
No they are in 'hh:mm:ss' format.
I cannot share the QVW as it contain very sensitive data unfortunately. Lots of graphs. :-(
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.