Group characteristic values and display text

[Former Member]

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

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

That's it!

Great! Thank you very much!

[Former Member]

Hi,

Definately it will repeat the value, but you can ignore this if you have no data in that combination. Just go for Zero row suppress which you can find in Query properties. Also allow zero suppress on structure level also, which you can find in Structure properties. Definately this will solve your problem.

Regards,