Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to create multiple groups

Hi,

i have column value as below

Column1

A

B

C

D

i need to create one more column as below where Group1 = A+B, Group2 = A+B+C+D, Group3 = A+D

Column2 - Grouping

Group1

Group2

Group3

please help me to achieve this

6 Replies
datanibbler
Esteemed Contributor

Re: How to create multiple groups

Hi savi,

can you elaborate a little more on that? Do you have, like I guess from your post, just 1 column with 4 stacked segments or do you have 4 columns?

Have you used any set_expressions for those?

Best regards,

DataNibbler

anbu1984
Honored Contributor III

Re: How to create multiple groups

Can you provide more details on your requirement? If you have more than four rows in input, then how will you form groups? Are you creating grouping column in the same table?

Not applicable

Re: How to create multiple groups

I have one column with 4 values and need to create grouping column in the same table

jonasheisterkam
Contributor III

Re: How to create multiple groups

It depents how you work with the groups. You can insert all groups in one field, but then you cant use it in the Listbox. You can use a Linktable or you can create more lines but then you must be carefull with aggregations.

Not applicable

Re: How to create multiple groups

yes I need to show these groups in the list box

saurabh5
Contributor II

Re: How to create multiple groups

hi savi,

Does the grouping based on a perticular pattern or it is a preset groups, if so then you need to create a new field using if condition for each field value for the new column.

Community Browser