function group

[fmazzarelli]

hi,

i'm creating a linear table.

Customer data is repeated many times.

PLUTO                    100
PIPPO                    100

PIPPO                    100

PIPPO                    100

PAPERINO             100

May I combine it?

PLUTO               100

PIPPO               300

PAPERINO        100

[sunny_talwar]

In the front end you can do this:

Dimension: Customer

Expression: Sum(Value)

If you want a back end solution you can do this:

Table:

LOAD * Inline [

Customer, Value

PLUTO,    100

PIPPO,    100

PIPPO,    100

PIPPO,    100

PAPERINO, 100

];

Join (Table)

LOAD Customer,

  Sum(Value) as TotalValue

Resident Table

Group By Customer;

[sunny_talwar]

Fabio, did it resolved your issue? or are there things you still need help with??? If everything is resolved, I would suggest closing this thread by marking the answer as correct, if not then please let me know what else is needed.

Best,

Sunny

[qlikviewwizard]

Hi fmazzarelli

Use Pivot table.