cancel
Showing results for 
Search instead for 
Did you mean: 

Group characteristic values and display text

Former Member
0 Kudos

Hello,

I would like to group some characteristics into a new variable. For this I've used structures without any problem. Now I would like to display the characteristic texts I've grouped.

For exemple I would like:

Group1...Text1

.............Text2

.............Text3

Group2...Text4

.............Text5

When I add into my row selection texts I get as results a repetition of all texts inside all groups, even if I don't have any value:

Group1...Text1

.............Text2

.............Text3

.............Text4

.............Text5

Group2...Text1

.............Text2

.............Text3

.............Text4

.............Text5

Can someone help me?

Thanks,

Benoit

View Entire Topic
Former Member
0 Kudos

It means all the group have all the texts. In this case you either need to compound the group and texts for getting unique combinations.

Former Member
0 Kudos

Thanks for your hint.

No, Group1 is a group of characteristics which contains Text1, Text2 and Text3, as well as Group2 which contains Text4 and Text5 so values can't exist for all. They are either in 1 group or in the other.

Benoit

Former Member
0 Kudos

Hi, Have you done Zero suppress, it will automatically take care of this.

Now logic behind why query behave like this.

Here you have created a structure on Text , so Structure is Fix Component of Query. Now while you put Group Before this, it means you are drill down query on Groups, at that time after every group, Fixed structure will repeat. Just think How query knows which part of structure is attached with which group?

Former Member
0 Kudos

That's it!

Great! Thank you very much!