Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...;
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...;