Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

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

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_namePointsSales_group_name
Smith10Alcohol
Lincoln10Deserts
Stark10Alcohol
Stark20Salads
Stark10Soup
Smith30Salads
Lincoln10Soup
Smith10Alcohol
Smith20Deserts
Lincoln10Deserts

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

Last_nameAlcoholDesertsSoupSaladsTotal points
Smith20003050
Lincoln02010030
Stark100102040

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!

1 Solution

Accepted Solutions
Highlighted
qlikmsg4u
Valued Contributor

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

dobruzky

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

View solution in original post

12 Replies
Highlighted

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

Use a Generic Load.

The Generic Load

Highlighted
qlikmsg4u
Valued Contributor

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

dobruzky

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

View solution in original post

Highlighted
Not applicable

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

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..

Highlighted
qlikmsg4u
Valued Contributor

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

Hold and Drag the Sales_Group column to right up corner

Untitled.png

Highlighted
Not applicable

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

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.

screenshot 5.png

screenshot 6.png

screenshot 7.png

Highlighted
qlikmsg4u
Valued Contributor

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

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.

Highlighted
Not applicable

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

screenshot 8.png

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?

Highlighted
qlikmsg4u
Valued Contributor

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

Glad! you did it.

For total follow this screen shot Capture.PNG

Highlighted
Not applicable

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

screenshot 9.png

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!