Advice to add fields during Load

pauledrich — Tue, 30 Jul 2013 09:36:56 GMT

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

Re: Advice to add fields during Load

Gysbert_Wassenaar — Tue, 30 Jul 2013 16:38:29 GMT

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...;

topic Re: Advice to add fields during Load in QlikView

Advice to add fields during Load

Re: Advice to add fields during Load