Advice to add fields during Load

[pauledrich]

Hi, new to Qlikview here and still getting my head around loading and expressions and would really appreciate some help.

I need to display the total value of an account where there are multiple fields that I need to group.

For example.....

I have fields with BranchLocation, AccountNumber and further fields A,B,C, D,E & F  each of which are the total weights of the item(s) in each of those catergories, and also row G which is the Total£'s.

I would like to be able to Group A,B ,C &D  as Group 1, E as Group 2 And F as Group 3.

And then show the groups as a Sum of Total£'s depending on the group.

I have tried to create a Dynamic expression - that simply didnt work.

Any suggestions on the best way forward would be appreciated.

Regards

P

[Gysbert_Wassenaar · Accepted solution]

If you want to create the fields in the script try:

Table1:

load

    BranchLocation

  , AccountNumber

  , rangesum(A,B,C,D) as Group1

  , E as Group2

  , F as Group3

from ...somewhere...;