topic Re: sum in QlikView

sum

upaliwije — Sat, 21 Jun 2014 08:57:58 GMT

I have a pivot table with following dimension and mesures

Dept Debit_Amount Settled_Amount Cancelled_Amount Balance

I have written the following expression to obtain balance But It is not giving desired result. Instead show 0 values

SUM( Debit_Amount -Settled_Amount -Cancelled_Amount)

Pls help me to correct the expression

its_anandrjs — Sat, 21 Jun 2014 09:24:04 GMT

I believe you use the column names if so then remove the SUM from the expression.

(Debit_Amount -Settled_Amount -Cancelled_Amount)

upaliwije — Sat, 21 Jun 2014 09:27:33 GMT

Thanks

Still the Balance value is zero

its_anandrjs — Sat, 21 Jun 2014 09:56:08 GMT

Please elaborate more

what is mean for Debit_Amount, Settled_Amount, Cancelled_Amount this are fields or column name in the chart.

upaliwije — Sat, 21 Jun 2014 10:04:21 GMT

load DEBIT_NOTE_NO,SETTLEMENT_DATE,SETTLED_AMOUNT AS SETTLED_AMOUNT;

sql

select Max(Ref_date)SETTLEMENT_DATE

,det_ref_C DEBIT_NOTE_NO ,

sum(NVL(det_hc_amt,0)) SETTLED_AMOUNT

from T_debtor

group by ref_C;

These are really fields as given above SETTLED_AMOUNT

Sat, 21 Jun 2014 12:11:55 GMT

Try with before function, otherwise share your sample.QVW

Regards,

Chinni

upaliwije — Sat, 21 Jun 2014 12:20:49 GMT

It is not working

upaliwije — Sat, 21 Jun 2014 12:25:22 GMT

I got the correct answer. The Expression should be as follows

sum(DEBIT_AMOUNT)-sum(SETTLED_AMOUNT)-SUM(CANCELLED_AMOUNT)

Thanks all