topic How to aggregate based on Condition in QlikView

How to aggregate based on Condition

Anonymous — Tue, 21 Aug 2018 21:59:53 GMT

Hello All,

I have one flat file with the following fields

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 — Wed, 22 Aug 2018 04:44:32 GMT

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 — Sat, 25 Aug 2018 15:39:25 GMT

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

andrey_krylov — Sat, 25 Aug 2018 19:24:05 GMT

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