How to group column data and use the name of the group as name of the column?

[#1]

Hello everybody, I'm very new to Qlikview and I'm trying to solve one problem for couple day but still stay clueless.

I have a table:

Last_name	Points	Sales_group_name
Smith	10	Alcohol
Lincoln	10	Deserts
Stark	10	Alcohol
Stark	20	Salads
Stark	10	Soup
Smith	30	Salads
Lincoln	10	Soup
Smith	10	Alcohol
Smith	20	Deserts
Lincoln	10	Deserts

In the end of all I need a table that will look like this:

Last_name	Alcohol	Deserts	Soup	Salads	Total points
Smith	20	0	0	30	50
Lincoln	0	20	10	0	30
Stark	10	0	10	20	40

Could you suggest any options for doing this?

I'm downloading data from the DB, first I've tried pivot table but its not working as I need, maybe I need to use some expressions or smth.

Thank you in advance!

[Colin-Albert]

Use a Generic Load.

The Generic Load

[qlikmsg4u · Accepted solution]

dobruzky

You can achieve in front end using pivot table, if you need it in script level then go for The Generic Load

[#4]

Thank you very much for your help! Could you please explain me how to put all the group names on top, when I'm creating a pivot table they used to appear on the left column..

[qlikmsg4u]

Hold and Drag the Sales_Group column to right up corner

[#6]

I still have problems, maybe because my example table is easier then actual one in qlikview.

In my actual pivot table I'm using two dimensions Last_name and Sales_group_name and I'm also using and expression that calculates sum(points). I'm draging fields but still don't have desirable result.

[qlikmsg4u]

Attach your sample app, we can do it for you.

If not possible, hold salescript_group_name and drag that to top right upper hand corner.

[#8]

YEY! It finally changed!!! Thank you a lot! Sorry I can't send you application now coz I'n working in QlikView via RDC

Could you also help me with one more thing, how to add to this table Total column from the right side?

Thank you!

P.S. could I add you in Skype or smth?

[qlikmsg4u]

Glad! you did it.

For total follow this screen shot

[#10]

Thats amaizing!!! Thank you so much!

I'm embraced now but could you also tell me how to make in this table sorting by date or maybe better to create a list with dates apart from the table or use slider for this purpose?

Thank you!