topic Re: function group in QlikView

function group

fmazzarelli — Thu, 18 Jun 2015 13:14:07 GMT

hi,

i'm creating a linear table.

Customer data is repeated many times.

PLUTO 100
PIPPO 100

PIPPO 100

PAPERINO 100

May I combine it?

PLUTO 100

PIPPO 300

PAPERINO 100

Re: function group

sunny_talwar — Thu, 18 Jun 2015 13:21:21 GMT

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

PAPERINO, 100

];

Join (Table)

LOAD Customer,

Sum(Value) as TotalValue

Resident Table

Group By Customer;

Re: function group

sunny_talwar — Thu, 18 Jun 2015 13:58:32 GMT

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

Re: function group

qlikviewwizard — Thu, 25 Jun 2015 02:20:26 GMT

Hi fmazzarelli

Use Pivot table.