Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Will you Please share the formula and what you want to achieve as I don't find any formula in excel
Yellow field has only a numeric value.
The formula in the yellow cell is : =-(1-(J12/K12))
I am not able to find formula column in attached excel.
Use TOTAL Keyword
-(1-(sum(total<dimen1,dim2> [TMT Pondéré])/sum(total<dimen1,dim2> [TMT Cible Pondéré])))
In a text box, = -(1-Sum(J)/Sum(K))