topic Re: SUB TOTAL in QlikView

SUB TOTAL

upaliwije — Mon, 03 Oct 2016 10:34:22 GMT

In my below Pivot Tbale sub total are not shown for all policies Last policy where there is only one entry sub total is shown. Pls help me to correct this

RISK	POLICY_NO	REF_NO	TRAN_TYPE	TRAN_DATE	IF(D_C='D',SUM(AMOUNT))	IF(D_C='C',SUM(AMOUNT))
SPRV2634	AK00121H0000004	AK0015D0014840	DEBIT	03-Nov-15	3,391	-
SPRV2634	AK00121H0000004	AK0016R0045941	SETTLEMENT	07-Jan-16	-	3,391
SPRW8596	AK00151H0000006	AK0016D0016624	DEBIT	01-Jun-16	4,352	-
SPRW8596	AK00151H0000006	AK0016C0002889	CANCELLED	19-Sep-16	-	4,352
SPRW2654	AK00111H000003	AK0016D0017268	DEBIT	12-Aug-16	4,010	-
SPRW2654	Total				4,010	-

Re: SUB TOTAL

rajpreeths — Mon, 03 Oct 2016 10:40:19 GMT

Could you please share your application with sample data here ???

Re: SUB TOTAL

qlikview979 — Mon, 03 Oct 2016 11:06:24 GMT

Hi ,

Can you Pls Share the Sample app

Regards

Mahesh

Re: SUB TOTAL

stabben23 — Mon, 03 Oct 2016 11:15:58 GMT

Hi, use set Expression instead. sum({<D_C={'D'}>}Amount), sum({<D_C={'C'}>}Amount).

Re: SUB TOTAL

upaliwije — Mon, 03 Oct 2016 11:21:54 GMT

TKS IT IS WORKING