How to aggregate based on Condition

[Anonymous]

Hello All,

I have one flat file with the following fields

TRNID	TRNFLG	BSFLG	PRDTYPE	ADDAMT	ORGAMT
1	D	S	90022	1000	3000
2	DA	B	90033	2000	2000
3	C	S	90026	2500	1500
4	D	B	90021	3500	800
5	DA	S	90021	4000	600
6	D	S	90026	2000	400
7	D	B	90024	2700	300

using load statement ,I wanted to calculate :

1. SUM(ADDAMT)  when TRNFLG in('D','DA','C','E')

2. SUM(ORGAMT)  when TRNFLG='D' and BSFLG='S' and  PRDTYPE in(90022,90021,90033,90026)

Can you help if I can get both the values calculated and displayed in Qlikview

Regards

Paul

Message was edited by: Paul Reddy

[andrey_krylov]

Maybe using set analysis

1. SUM({< TRNFLG={'D','DA','C','E'} >}ADDAMT)

2. SUM({< TRNFLG={'D'}, BSFLG={'S'},  PRDTYPE={'90022','90021','90033','90026'} > }ORGAMT)

[Anonymous]

‌thank you Andrey. Do I add this in load script?

[andrey_krylov]

No Paul, these expressions are for chart. You can do something similar in load script, but what for? Could you please clarify the issue?