Discussion Board for collaboration related to Creating Analytics for QlikView.
I currently have a straight table will a few expressions calculating the required fields. One of these expressions is returning me the right value on each record but the wrong value in total.
I have changed the "Total mode" on the straight table to Sum the total value is right now.
But the issue now is that I need the total from the above in the neted expression to work out %.
I think the function required is aggr but not 100 sure how to get this working.
(sum(A)/sum(TOTAL <CUST> A))*sum(TOTAL <CUST_NAME> B)
values in the records are
total of 2.3
If i put the expression on a text box the answer is zero.