SUM

[upaliwije]

Hi Friends

This is how data in my data model appear

CLAIM_NO	LOSS_DATE	POLICY_NO	AMOUNT	POLICY_PERIOD	PREMIUM	DESC
		GN00111A0000119	1200	Aug-12 - Aug-13	14505	SRCC TO VEHICLE
		GN00111A0000119	1400	Aug-12 - Aug-13	14505	FLOOD COVER AND  NATURAL PERILS
		GN00111A0000119	14000	Aug-12 - Aug-13	14505	BASIC PREMIUM
		GN00111A0000119	5	Aug-12 - Aug-13	14505	ROAD SAFETY FUND
		GN00111A0000119	-2100	Aug-12 - Aug-13	14505	NO CLAIM BONUS
		GN00111A0000119	1200	Aug-14 - Aug-15	13105	SRCC TO VEHICLE
		GN00111A0000119	1400	Aug-14 - Aug-15	13105	FLOOD COVER AND  NATURAL PERILS
		GN00111A0000119	-3500	Aug-14 - Aug-15	13105	NO CLAIM BONUS
		GN00111A0000119	14000	Aug-14 - Aug-15	13105	BASIC PREMIUM
		GN00111A0000119	5	Aug-14 - Aug-15	13105	ROAD SAFETY FUND
		GN00111A0000119	0	Aug-14 - Aug-15	13105	FREE HEALTH COVER
CLGN001A15000021	06-Mar-15	GN00111A0000119		Aug-14 - Aug-15
CLGN001A15000021	06-Mar-15	GN00111A0000119		Aug-14 - Aug-15
CLGN001A15000023	08-Mar-15	GN00111A0000119		Aug-14 - Aug-15
CLGN001A15000036	15-Apr-15	GN00111A0000119		Aug-14 - Aug-15
CLGN001A15000063	16-Jul-15	GN00111A0000119		Aug-14 - Aug-15
CLGN001A15000063	16-Jul-15	GN00111A0000119		Aug-14 - Aug-15

I write the following expression but I do get sum of Amount Under Premium Column in below output report

if(len(trim(CLAIM_NO))>0, sum(AMOUNT))

output report

RISK	POLICY_PERIOD	LOSS_DATE	POLICY_NO	CLAIM_NO	PREMIUM
17-6819	Aug-12 - Aug-13	-	GN00111A0000119	-	-
17-6819	Aug-12 - Aug-13	Total			-
17-6819	Aug-13 - Aug-14	-	GN00111A0000119	-	-
17-6819	Aug-13 - Aug-14	Total			-
17-6819	Aug-14 - Aug-15	06-Mar-15	GN00111A0000119	CLGN001A15000021	0
17-6819	Aug-14 - Aug-15	08-Mar-15	GN00111A0000119	CLGN001A15000023	0
17-6819	Aug-14 - Aug-15	15-Apr-15	GN00111A0000119	CLGN001A15000036	0
17-6819	Aug-14 - Aug-15	16-Jul-15	GN00111A0000119	CLGN001A15000063	0
17-6819	Aug-14 - Aug-15	-	GN00111A0000119	-	-
17-6819	Aug-14 - Aug-15	Total			-
17-6819	Aug-15 - Aug-16	-	GN00111A0000119	-	-
17-6819	Aug-15 - Aug-16	Total			-
17-6819	Total				-
Total					-

-

Pls help me to trace the error

[petter]

You output report - what is it? It looks like a Pivot Table due to the different Sub Totals ...

But the repeated values for the dimensions tells me otherwise?

Do you have some example spreadsheet and an explanation on what you have made in QlikView already - or even an upload of the QVW to share?