Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe using set analysis
1. SUM({< TRNFLG={'D','DA','C','E'} >}ADDAMT)
2. SUM({< TRNFLG={'D'}, BSFLG={'S'}, PRDTYPE={'90022','90021','90033','90026'} > }ORGAMT)
thank you Andrey. Do I add this in load script?
No Paul, these expressions are for chart. You can do something similar in load script, but what for? Could you please clarify the issue?