Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Total Mode (SUM)

Guys

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.

Example below.

(

    (

    (sum(A)/sum(TOTAL <CUST>  A))*sum(TOTAL <CUST_NAME>  B)

    )

*

    (if(isnull(Sum(NET)/sum(A))=-1,0,Sum(NET)/sum(A))

    )

)

-

(

    (if(isnull(Sum(NET)/sum(A))=-1,0,Sum(NET)/sum(A))

    )

*

sum(B)

)

values in the records are

0.1

0.4

0.5

0.6

0.7

total of 2.3

If i put the expression on a text box the answer is zero.

thanks

S

Community Browser