Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to combine my G1 to G4 sales into one ?


Hi All


Due to now my sales team G1 to G4 are combine into one group.


Before the G1 to G4 combine , Below is the table 1 :-


GROUP_CLASS....sum(sales)

99..............8800

G1 ...........5,009,844

G2 ...........6,060,906

G3 ...........7,030,611

G4 ...........4,214,878

G5 ...........2,863,171

G6 ...........217,116

G7 ...........1,467,594

G8 ...........276,725

G9 ...........4,395,156

G12 ...........271,674

G13 ...........381,544



I like to make the above table 1 to below , notice that G1-G4 sales are combine :-


GROUP_CLASS....sum(sales)

99.............8800

G1-G4..........22316238.89

G5 ...........2,863,171

G6 ...........217,116

G7 ...........1,467,594

G8 ...........276,725

G9 ...........4,395,156

G12 ...........271,674

G13 ...........381,544


Can some one advise me how to do it ?


Paul Yeo

Community Browser